Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003
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 |
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003
See if this might help
http://support.microsoft.com/default...b;en-us;327006 Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
All times are GMT +1. The time now is 11:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com