invalid references

S

Shooter

I created and have been usuing a workbook in excel 2003 with no problems. I
just upgraded to office 2007 and when I open the workbook I get the following
message..." a formula in this worksheet contains one or more invalid
references. Verify that your formulas contain a valid path, workbook,range
name and cell reference". I am wondering why I did not receive this message
with excel 2003 and how I locate the invalid cell reference? Thanks for your
assistance.
 
T

Thuizt

We encounter the same issue.
By selected a wrong cell and pressing F2 (edit) followed by just pressing
the enter key to confirm. The formula accepts normally.
Anyone recognizing this behaviour or better having a solution for it.

Thanks
 
G

Gord Dibben

Select one column and Data>Text to Columns>Finish

Works most of the time.

OR.....maybe numbers are text.

Format all to General, copy an empty cell.

Select all and Edit>Paste Special>Add>OK>Esc


Gord Dibben MS Excel MVP
 

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

Top