View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Transfering Workbook

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.

"doss04" wrote:

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

"Joel" wrote:

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" wrote:

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?