Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
error msg on opening excel workbook
I get an error msg when opening an Excel workbook that reads like this:
"Cannot find #REF!$B$1, which has been assigned to run each time [WorkbookName]TabName is opened. Continuing could cause errors. Cancel opening [WorkbookName]TabName?" I have looked at macros, right clicked on the tab name and selected view code, right clicked on the Excel icon to the left of 'File' on the toolbar and selected view code, and I don't see any macro or code. Thanks for your help. mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
error msg on opening excel workbook
Try looking for invalid external references. The find link utility by Bill
Manville will help you to lcate the issue. http://www.oaltd.co.uk/MVP/ -- HTH... Jim Thomlinson "lawandgrace" wrote: I get an error msg when opening an Excel workbook that reads like this: "Cannot find #REF!$B$1, which has been assigned to run each time [WorkbookName]TabName is opened. Continuing could cause errors. Cancel opening [WorkbookName]TabName?" I have looked at macros, right clicked on the tab name and selected view code, right clicked on the Excel icon to the left of 'File' on the toolbar and selected view code, and I don't see any macro or code. Thanks for your help. mike |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
error msg on opening excel workbook
Thank you! This worked.
"Jim Thomlinson" wrote: Try looking for invalid external references. The find link utility by Bill Manville will help you to lcate the issue. http://www.oaltd.co.uk/MVP/ -- HTH... Jim Thomlinson "lawandgrace" wrote: I get an error msg when opening an Excel workbook that reads like this: "Cannot find #REF!$B$1, which has been assigned to run each time [WorkbookName]TabName is opened. Continuing could cause errors. Cancel opening [WorkbookName]TabName?" I have looked at macros, right clicked on the tab name and selected view code, right clicked on the Excel icon to the left of 'File' on the toolbar and selected view code, and I don't see any macro or code. Thanks for your help. mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error msg on opening Excel Workbook | Excel Discussion (Misc queries) | |||
Error on opening Excel workbook | Excel Discussion (Misc queries) | |||
Error when opening Excel workbook | Excel Worksheet Functions | |||
compile error message on a new excel workbook opening | Excel Discussion (Misc queries) | |||
Error Opening an Excel Workbook | New Users to Excel |