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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,114,274
Messages
5,546,907
Members
410,763
Latest member
TSVIVI
Top