Linked Excel 2002 spreadsheet doesn't update in Word 2002

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DavidS - 08 May 2008 22:08 GMT

I have an Excel spreadsheet with a query to a sql database. The Excel file
auto updates from the sql database. I have created a text box in a Word 2002
document where I used the paste special command - paste link to Excel
worksheet object as the source of the link. When the Excel updates the linked
data in the Word document seems to lose connection due to row additions
and/or deletions.

Signature

Senior Business Analyst
SPG

Reply to this Message

CyberTaz - 08 May 2008 23:44 GMT

Hi David -

Sorry about the problem but this is the newsgroup for Mac Word:-) Although
some of us work both sides of the street I doubt we have 2002 readily
available for any poking around.

You'll probably have a much quicker & more definitive response if you post
to one of the PC Word groups you'll find here:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

They'll need full version information and [most likely] some rationale for
why there's a linked object pasted into a Text Box in the first place. That
may very well be the cause of the problem since the Text Box, itself, is
actually an embedded object to begin with.

Regards |:>)
Bob Jones
[MVP] Office:Mac

On 5/8/08 5:08 PM, in article
B93D4DFF-374E-4003-BFA2-91AB3E174E03@microsoft.com, "DavidS"

> I have an Excel spreadsheet with a query to a sql database. The Excel file
> auto updates from the sql database. I have created a text box in a Word 2002
> document where I used the paste special command - paste link to Excel
> worksheet object as the source of the link. When the Excel updates the linked
> data in the Word document seems to lose connection due to row additions
> and/or deletions.

Reply to this Message

Mac Forum / Applications / Word / May 2008

Linked Excel 2002 spreadsheet doesn't update in Word 2002