I have a macro that runs and performs a lot of work on numerous worksheet tabs and completes without error. However, when I go to save the file, I get a pop-up box with the error about invalid formula references ("A formula in this sheet contains one or more invalid references. Verify that your formulas contain a valid path, workbook, range name and cell reference.")
When I go to see which cell has the error (Formulas-->Error Checking), it tells me that there are no errors on this or any other sheet in the file. Has anyone else ever experienced anything like this?
FWIW, the tab in question has a pivot table and pivot chart on the tab, and the macro does set the range for the pivot table but it works correctly, so I'm not sure why I get the error.
When I go to see which cell has the error (Formulas-->Error Checking), it tells me that there are no errors on this or any other sheet in the file. Has anyone else ever experienced anything like this?
FWIW, the tab in question has a pivot table and pivot chart on the tab, and the macro does set the range for the pivot table but it works correctly, so I'm not sure why I get the error.
