Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transfering Workbook
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transfering Workbook
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transfering Workbook
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfering Info | Excel Discussion (Misc queries) | |||
Transfering 100 named ranges to an another workbook | Excel Discussion (Misc queries) | |||
Transfering Values | Excel Worksheet Functions | |||
Transfering Dos to Excel | Excel Discussion (Misc queries) | |||
Formulas not working after transfering to new workbook | Excel Worksheet Functions |