Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel 2000
I would like to get rid of the following error message. The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook? . To update all linked information, click Yes. . To keep the existing information, click No. The desired links are _always_ to named ranges (cells) in another worksheet in the current workbook, never to an external workbook. The links were originally generated/programmed to a second worksheet in the current workbook. The links have never been explicitly to another workbook, and the linked formulae just contain the range (cell) name, and do not contain any filename of any external workbook. The problem (arose) is generated by the fact that I need to delete the "data" worksheet with the named ranges, and then import, into the workbook with the "report," a different data worksheet with the same set of named ranges (cells), but different data (for a different accounting period). The data worksheet with the named ranges (cells) is a linear dump of the Trial Balance into an Excel worksheet/workbook by an accounting application. The report worksheet which references the named ranges is a financial report in an explicitly desired format that the accounting application doesn't seem to be able to produce. As long as I click "no," everything is fine, but if I give this to someone else to run, there will be problems. Is there, perhaps, any way to auto- answer this Msg Box with "No"? Thanks Fred Holmes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing Default Paste behavior | Excel Discussion (Misc queries) | |||
pivot w/ a different workbook as data source - odd behavior | Excel Discussion (Misc queries) | |||
changing a cell to changing the link | Excel Worksheet Functions | |||
Change in Link Behavior - Excel 2000 to 2003 | Links and Linking in Excel | |||
Changing Behavior of the <Enter Key? | Excel Discussion (Misc queries) |