error msg on opening excel workbook

L

lawandgrace

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
 
L

lawandgrace

Thank you! This worked.

Jim Thomlinson said:
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 said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error msg on opening Excel Workbook 1
Error on opening Excel workbook 2
Error msg on opening excel workbook 1
Excel Providing user message when RED X clicked & properly closing application. 2
problem when opening/closing worksheets 4
Error message adaytum.xla when closing workbook in Excel 2003 1
Problem (bug?) in the way Excel 2007 doesn't automatically load ma 8
Cannot find #REF!#REF error 0

Top