Although I am not a pro...

One way of solving this is if the location of the linked cells do not
change, and there are frequent updates to the server sheet is to code
it something like this

Sub StaticSave
Sheets("NON-SERVER PAGE").RANGE("A1").FORMULA = "=SHEETS("SERVER
PAGE").RANGE("<LINKED CELL")"
Sheets("NON-SERVER PAGE").RANGE("A1").COPY
Sheets("NON-SERVER PAGE").RANGE("A1").PASTESPECIAL xlValues
End Sub

and repeat the code for each linked range. I am sure there is a better
solution, but this would work and allow you to update it when the server
sheet is updated.


--
patrickcairns
------------------------------------------------------------------------
patrickcairns's Profile: http://www.excelforum.com/member.php...o&userid=31790
View this thread: http://www.excelforum.com/showthread...hreadid=515163