Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / October 2005

Tip: Looking for answers? Try searching our database.

Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rich Rodberg - 20 Oct 2005 19:12 GMT
We have started migrating users in our Finance Group from Office 2000 to
Office 2003.

Once a month a worksheet is created with from 15-20 different referenced
worksheets all created in Excel 2000. When our user with Excel 2003 opens
the workbook, none of the data is displayed whether update or don't update
is selected.

Edit > Links displays all of the referenced worksheets.

We are able to open each of the referenced worksheets and once opened and
the common file saved the links are formed and work.

Is there a shortcut so the user does not have to open all of the referenced
sheets?

Just so you know, all users are able to open a worksheet created in Excel
2003 whether using Excel 2000 or 2003 and all of the users running Excel
2000 are able to open the file and the data is correct.

Thanks
Bill Manville - 21 Oct 2005 07:53 GMT
See if this might help

http://support.microsoft.com/default.aspx?scid=kb;en-us;327006

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.