fatboy_1989
New Member
- Joined
- Oct 10, 2014
- Messages
- 19
Hi,
I have a strange situation. I have a formula in a spreadsheet that links to another:
='I:\[A.xls]Sheet1'!C100
For some reason the following is occurring:
Whilst 'I:\[A.xls]Sheet1'!C100 is closed
If I have the 'I:\[A.xls]Sheet1'!C100 spreadsheet open
Why can I not use the F9 option when the linked spreadsheet is closed?
I also have a very long formula that incorporates maybe 45 different cells from linked spreadsheets.
I want to be able to use F9 on say the 30th value to see this value.
Otherwise I have to evaluate formula to see what this 30th part is, which takes much longer to do.
What can I do to allow me to use the F9 option?
Thanks
I have a strange situation. I have a formula in a spreadsheet that links to another:
='I:\[A.xls]Sheet1'!C100
For some reason the following is occurring:
Whilst 'I:\[A.xls]Sheet1'!C100 is closed
- If I highlight the 'I:\[A.xls]Sheet1'!C100 and press F9 I get a #Ref
- If I go to Formulas --> Formula Auditing --> Evaluate Formula then the 'I:\[A.xls]Sheet1'!C100 evaluation does show me a number (not the #Ref )
If I have the 'I:\[A.xls]Sheet1'!C100 spreadsheet open
- then the F9 option now works and does not return the #Ref
- Evaluate Formula also continues to work as in scenario 1
Why can I not use the F9 option when the linked spreadsheet is closed?
I also have a very long formula that incorporates maybe 45 different cells from linked spreadsheets.
I want to be able to use F9 on say the 30th value to see this value.
Otherwise I have to evaluate formula to see what this 30th part is, which takes much longer to do.
What can I do to allow me to use the F9 option?
Thanks