error msg on opening excel workbook
in [General]
|
Prev: Excel macros graphs work on one laptop, but do not on another. Wh
Next: ActiveX Command Button - Snap to Cell Boundaries
From: lawandgrace on 9 Feb 2010 15:25 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
From: Jim Thomlinson on 9 Feb 2010 15:48
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 |