Sarah Jane H
New Member
- Joined
- Jul 2, 2010
- Messages
- 14
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>
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>