link source data

[Guest]

I worked on employees data in excel version 2002, the worksheet contain lots
of formulas, when i email the file to my supervisors, she get a message
stating "This Workbook contains link to other data sources", i either to
choose update or not to update icons, what ever i choose, the cells that
contain fomulas switch to #Name or #Value. please help me asap what is the
problem, i tried many times to solve it but i gave up.
please let me know

 

[Guest]

One way would be to open a new spreadsheet, select the whole employee data
worksheet, copy, go to the new spreadsheet, paste special, values. Your
supervisor won't be able to update and have the formulas work, because the
formulas are not moving to the new spreadsheet.

Another way would be to find what the link is. There are several
suggestions in the excel community - just do a search on "link".

Hope this helps,
Carole O

 

[Dave Peterson]

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/[email protected]

Maybe it'll work for you.

 

[Dave Peterson]

I bet you meant Bill Manville's FindLink addin:
http://www.oaltd.co.uk/MVP/Default.htm