Hi All,
I'm having issues saving a .xls file in Excel 2007. It contains lots of formatting, and linked data. The file opens easily for users in Excel 2003, but crashes Excel 2007 for all users. When the user opens the file in excel 2007 it continuously shows the below message atleast seven to eight times and after that if the user tries to just save the file the entire excel gets crashed.
Error Message: [VBA]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.[/VBA]
I tried to check all sheets of the workbook to find the erroneous formula in them but unfortunately I couldn't get any such cells I using the error checker from formula auditing tool. The file opens fine in excel 2003 and gets saved as well without throwing any error but most of other users in our workplace have 2007 installed on their system and they are unable to work on the file. Please expedite.
Thanks for your help in advance.
I'm having issues saving a .xls file in Excel 2007. It contains lots of formatting, and linked data. The file opens easily for users in Excel 2003, but crashes Excel 2007 for all users. When the user opens the file in excel 2007 it continuously shows the below message atleast seven to eight times and after that if the user tries to just save the file the entire excel gets crashed.
Error Message: [VBA]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.[/VBA]
I tried to check all sheets of the workbook to find the erroneous formula in them but unfortunately I couldn't get any such cells I using the error checker from formula auditing tool. The file opens fine in excel 2003 and gets saved as well without throwing any error but most of other users in our workplace have 2007 installed on their system and they are unable to work on the file. Please expedite.
Thanks for your help in advance.
