Lock all Links in Excel 2000
Posted by Judy on October 17, 2000 7:10 AM
I have 30 worksheets in a workbook with unique external links in each data cell to several external workbooks, worksheets and cells. I am wanting to save the workbook containing the 30 worksheets into a new workbook and save the original workbook (with the 30 worksheets) in the original file with the links locked (not updating for any changes in the source file.) At some point in the future I may need to reactivate those links. However I do not want that to happen or the updating for external data as an option for anyone opening the original workbook. So I want the linking formulas to stay but not update when locked. I plan to change the data in the source file and utilize all of the same external links in the new saved workbook and worksheets to produce updated reports. I have tried to "Lock all Links in Microsoft Excel" as instructed in their Help section. When I go to Tools, Options and on the Calculation Tab clear the "Update remote references" check box it will not save this way. When the file is reopened the checkbox is again there and all of the external data links are updated with external data. This does not appear to be working or I am doing something wrong. Any ideas?