Links to shared spreadsheets

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>
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Watch MrExcel Video

Forum statistics

Threads
1,109,456
Messages
5,528,868
Members
409,842
Latest member
mfernandezcean
Top