| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
WHAT COULD CAUSE #Ref error ON UNLINKED SHEETS
DEAR ALL
I HAVE A FILE BY NAME SAY CARGO.XLS. In this file there are 20 sheets. In VB i transfer the say three sheets from the cargo.xls file for transmitting from the cargo control to the radio room. What i cant figure out is if I open one sheet and then the other some of the cells get # ref error. For your information-- I do not have any links in the cells showing this error. The formulas in these sheets are referring to the sheet cells itself. What could be the cause. Pls advice. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
WHAT COULD CAUSE #Ref error ON UNLINKED SHEETS
If your formulas refer to a cell in column A, and you delete column A, the
reference to the cell is changed to #REF! - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "CAPTGNVR" wrote in message oups.com... DEAR ALL I HAVE A FILE BY NAME SAY CARGO.XLS. In this file there are 20 sheets. In VB i transfer the say three sheets from the cargo.xls file for transmitting from the cargo control to the radio room. What i cant figure out is if I open one sheet and then the other some of the cells get # ref error. For your information-- I do not have any links in the cells showing this error. The formulas in these sheets are referring to the sheet cells itself. What could be the cause. Pls advice. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
WHAT COULD CAUSE #Ref error ON UNLINKED SHEETS
On Feb 12, 11:46 pm, "Jon Peltier"
wrote: If your formulas refer to a cell in column A, and you delete column A, the reference to the cell is changed to #REF! - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutionshttp://PeltierTech.com _______ "CAPTGNVR" wrote in message oups.com... DEAR ALL I HAVE A FILE BY NAME SAY CARGO.XLS. In this file there are 20 sheets. In VB i transfer the say three sheets from the cargo.xls file for transmitting from the cargo control to the radio room. What i cant figure out is if I open one sheet and then the other some of the cells get # ref error. For your information-- I do not have any links in the cells showing this error. The formulas in these sheets are referring to the sheet cells itself. What could be the cause. Pls advice. D/PETER, thnks ur response. In radio room i open the first sheet exported and it is fine. I open the second sheet and it is also fine. When i go back to the first sheet then it shows these ref errors in cells. All these days i did not face this and unable to ustand the reason for this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete sheets from a workbook without creating linked formulae | Excel Discussion (Misc queries) | |||
| selecting a single sheet from a volume of sheets in a workbook | Excel Worksheet Functions | |||
| question about many sheets in one warkbook | Excel Worksheet Functions | |||
| Microsoft Visual Basic: Compile error: Sum or Function not defined | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
Linear Mode
