Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
invalid references
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. -- Shooter |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
invalid references
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 "Shooter" wrote: 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. -- Shooter |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
invalid references
Select one column and DataText to ColumnsFinish
Works most of the time. OR.....maybe numbers are text. Format all to General, copy an empty cell. Select all and EditPaste SpecialAddOKEsc Gord Dibben MS Excel MVP On Mon, 14 Jan 2008 13:53:03 -0800, Thuizt wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing data and "invalid references" | Charts and Charting in Excel | |||
invalid references in formula | Excel Discussion (Misc queries) | |||
"A formula in worksheet contains 1 or more invalid references?" | Charts and Charting in Excel | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
" invalid cell references. | Excel Worksheet Functions |