Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
GHawkins GHawkins is offline
external usenet poster
 
Posts: 4
Default Embedded Excel spreadsheet in Word Document - cannot update data

We are running Office 2003, SP2 on Windows XP machines. I have a Word
document with an embedded spreadsheet. When I go into the embedded
spreadsheet to change/add data, the changes are reflected when I click out of
the sheet to return to the Word document.

However, one user is having problems updating the spreadsheet. When he
changes a value within the Excel table (such as changing a 0 to 3) and then
returns to the Word document, the updated values are not shown in the "Word
view". If he clicks back into the Excel table the changed values are
reflected correctly.

We have had 4+ people try to edit the table - only one person is having this
problem. I assume it's a setting either in Word or Excel. Anyone with ideas
on how to fix it would be greatly appreciated!!
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Embedded Excel spreadsheet in Word Document - cannot update data

Hi GHawkins,

Is the user who is having the problems making the changes with the Word
document closed? And do they have the 'update automatic links at open'
checked under Tools|Options|General? If it's a print-time problem, it's also
worth checking that the 'update links' option is checked under
Tools|Options|Print.

Cheers

--
macropod
[MVP - Microsoft Word]


"GHawkins" wrote in message
...
We are running Office 2003, SP2 on Windows XP machines. I have a Word
document with an embedded spreadsheet. When I go into the embedded
spreadsheet to change/add data, the changes are reflected when I click out

of
the sheet to return to the Word document.

However, one user is having problems updating the spreadsheet. When he
changes a value within the Excel table (such as changing a 0 to 3) and

then
returns to the Word document, the updated values are not shown in the

"Word
view". If he clicks back into the Excel table the changed values are
reflected correctly.

We have had 4+ people try to edit the table - only one person is having

this
problem. I assume it's a setting either in Word or Excel. Anyone with

ideas
on how to fix it would be greatly appreciated!!



  #3   Report Post  
Posted to microsoft.public.word.tables
GHawkins GHawkins is offline
external usenet poster
 
Posts: 4
Default Embedded Excel spreadsheet in Word Document - cannot update da

The Word document is open when he's editing it. I looked through his
settings, but I can't say that I remember what he had for those two. I'll
check those!

"macropod" wrote:

Hi GHawkins,

Is the user who is having the problems making the changes with the Word
document closed? And do they have the 'update automatic links at open'
checked under Tools|Options|General? If it's a print-time problem, it's also
worth checking that the 'update links' option is checked under
Tools|Options|Print.

Cheers

--
macropod
[MVP - Microsoft Word]


"GHawkins" wrote in message
...
We are running Office 2003, SP2 on Windows XP machines. I have a Word
document with an embedded spreadsheet. When I go into the embedded
spreadsheet to change/add data, the changes are reflected when I click out

of
the sheet to return to the Word document.

However, one user is having problems updating the spreadsheet. When he
changes a value within the Excel table (such as changing a 0 to 3) and

then
returns to the Word document, the updated values are not shown in the

"Word
view". If he clicks back into the Excel table the changed values are
reflected correctly.

We have had 4+ people try to edit the table - only one person is having

this
problem. I assume it's a setting either in Word or Excel. Anyone with

ideas
on how to fix it would be greatly appreciated!!




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word should catalog misspelled words to study. rndthought Microsoft Word Help 39 May 21st 23 02:47 AM
Index Match in Word Table, or Embedded Excel? TomorrowsMan Microsoft Word Help 3 September 21st 06 08:38 PM
Detach or change SQL data source for Word template, and other Qs SJMac Mailmerge 6 July 27th 06 10:12 AM
WP merge file to Word sstires Tables 4 February 14th 06 06:26 PM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 09:02 AM


All times are GMT +1. The time now is 10:21 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"