Prev: How do I change the font in the formular bar in EXCEL 2007?
Next: Macro to hide rows with zero values in columns
From: lawandgrace on 11 Feb 2010 12:16
I receive the following error msg when opening an excel workbook:

"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?"

There is no macro associated with this workbook. I have right-clicked on the
excel icon to the left of 'File' on the toolbar and also on the tab name, and
there is no code that I can see.

Thank you.

mike
From: lawandgrace on 11 Feb 2010 13:31
Please ignore this post. I am having problems 'seeing' my posts when I do a
search for them (they don't show).

"lawandgrace" wrote:

> I receive the following error msg when opening an excel workbook:
>
> "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?"
>
> There is no macro associated with this workbook. I have right-clicked on the
> excel icon to the left of 'File' on the toolbar and also on the tab name, and
> there is no code that I can see.
>
> Thank you.
>
> mike
From: lawandgrace on 11 Feb 2010 14:17
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
 | 
Pages: 1
Prev: How do I change the font in the formular bar in EXCEL 2007?
Next: Macro to hide rows with zero values in columns