| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook with external links shows REF! error in 2007 not in 2003
I have a workbook that was created in Excel 2003. It has multiple links to
external data sources that are not available to all users. When the workbook is opened in Excel 2003 and the user Selects "Do not Update", they can see the last values in the workbook. When this same workbook is opened in Excel 2007, the linked cells give REF! errors. How do I get the file to open correctly in 2007 and show the last data values instead of the REF! error? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook 2007 icon shows error - where is it? | Excel Discussion (Misc queries) | |||
| fixing links to external files if status shows OK | Excel Discussion (Misc queries) | |||
| Links to External Workbook | Excel Worksheet Functions | |||
| how can i delete external links from my workbook | Excel Discussion (Misc queries) | |||
| Named range links to external workbook, help! | Charts and Charting in Excel | |||
Linear Mode
