alexthecamel
New Member
- Joined
- Jul 6, 2004
- Messages
- 47
Hi All,
I've got some strange behaviour on one of my sheets.
When I link one cell to another on a diferent sheet, Excel appears to be changing the location from a short on to it's full location, but adding in a date, eg:
=[Day16.xls]Summary!I4
is being changed to
='S:\@GMT-2011.10.25-11.00.56\MyFolderName\MyData\Daily Calcs\[Day16.xls]Summary'!$I4
No idea where the "@GMT-2011.10.25-11.00.56" is coming from.
Thanks in advance.
I've got some strange behaviour on one of my sheets.
When I link one cell to another on a diferent sheet, Excel appears to be changing the location from a short on to it's full location, but adding in a date, eg:
=[Day16.xls]Summary!I4
is being changed to
='S:\@GMT-2011.10.25-11.00.56\MyFolderName\MyData\Daily Calcs\[Day16.xls]Summary'!$I4
No idea where the "@GMT-2011.10.25-11.00.56" is coming from.
Thanks in advance.