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.

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.

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.