Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#REF! after opening a spreadsheet
I have a spreadsheet with links to other spreadsheets
When I open my file, there is a message about re-establishing the links. Most of the time there is no changes in the other file, so my answer is no. At some occasion, the cells refeing to the other files show #ref! instead of the values that were there when I last closed the file The solution is for me to open the othe file and then close it. The links are now reestablished However at the next occasion, it starts all over again. What is it and is there a solution Thanks AG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening more than 1 Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Opening a spreadsheet in excel | Excel Discussion (Misc queries) | |||
opening a spreadsheet | New Users to Excel | |||
Opening a spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet not opening correctly | Excel Discussion (Misc queries) |