| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get rid of "A formula in this worksheet contains one or moreinvalid references"
Frequently I'll delete some cells in an Excel 2007 worksheet and from
then on get the message "A formula in this worksheet contains one or more invalid references." whenever I try to do anything in the worksheet. There are no invalid references, as I have verified. Possibly there were some temporarily while Excel was in the process of deleting the cells. If I save the file, exit Excel, then reopen the workbook, Excel changes its mind and decides there aren't any invalid references after all (at least the message goes away). Is there any way to get Excel to figure this out with shutting it down? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "A formula in worksheet contains 1 or more invalid references?" | Charts and Charting in Excel | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| cell references increase by 3 per row "=I1" then "=I4" | Excel Discussion (Misc queries) | |||
![coffent[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
