Links to shared spreadsheets

[Sarah Jane H]

Hello

Do you ever have your formulas go weird on a sheet even though you haven’t opened it for months?</SPAN></SPAN>

My formulas to linked sheets went from </SPAN></SPAN>

='S:\Projects\4.0 Administration\4.1 Timesheets\FY14 Timesheets\[B Geer Timesheet FY14.xlsx]Summary'!$D19</SPAN></SPAN>


='S:\@GMT-2014.07.21-06.00.28 Projects\4.0 Administration\4.1 Timesheets\FY14 Timesheets\[B Geer Timesheet FY14.xlsx]Summary'!$D19</SPAN></SPAN>

And I don’t know how it happens and it takes ages for me to put it straight?</SPAN></SPAN>

Any clues greatly appreciated.</SPAN></SPAN>

 

[Sarah Jane H]

Still no reply Can anyone help please.

 

[Sarah Jane H]

Help please!