invalid reference error saving 2003 file in 2007

G

Gary C

I have a large workbook (50+ worksheets) that originated in Excel 2003. I
would like to save it as a 2007 workbook so I can get larger worksheets. When
I try to save it as 2007 file, I get an error message "A formula in this
worksheet contains one or more invalid references." Is there any way to save
this in Excel 2007 format without actually finding and correcting the invalid
references. I'm sure that there are many invalid references in the many
spreadsheets and I don't have to time to find every one. I have not had any
problems with the Excel 2003 format.
Thanks.
Gary C
 

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

How to get rid of "A formula in this worksheet contains one or moreinvalid references" 0
persistent "invalid reference" error message 2
Finding one or more "Invalid References" in big spreadsheet 1
Excel 2003 save as .XLSX 12
Opening Office 2003 excel file in Office Excel 2007 1
Formula with Invalid References Error Message 5
Save workbook without shapes 0
script error 0

Top