Transfering Workbook

[doss04]

I copied my workbook to a jumpdrive so that i can put it on another comp. But
when i pasted it to the other comp. none of my formulas worked. The comps are
not networked. What do I need to do to make it work?

 

[Joel]

If there are links in your wrokbooks to other files it will never work unless
you convert the lined cells to values bewfore you transfer the data to
another computer.

First make a copy of the workbook on the original computer. then go to
worksheet menu Edit - Links. Next you have to break the links. Then save
the file to your jumpdrive.

 

[doss04]

Thanks: For some reason the LINKS word isnt able to be clicked on. it's faded
lettering.

 

[Joel]

This indicates you have no referenced cells in your formulas like
=[book1.xls]sheet1!A1

You probably have some hyperlinks. You can find the hyperlinks by using
EDIT - FIND. go to options and change worksheet to entire workbook. then in
the Find box put in C:\ or any other dirves you are using.