| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 97-remove link but keep data
Hi guys,
I have a pre-existing excel 97 s/s which has links to other s/s's. I would like to keep the data only (like paste-special, values) and remove the linked reference from showing in the current s/s. Any ideas how to do this instead of me changing each linked reference? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 97-remove link but keep data
search for .xls or [ or ] to see if you can find the formulas that contain links
to other workbooks. Van wrote: Hi guys, I have a pre-existing excel 97 s/s which has links to other s/s's. I would like to keep the data only (like paste-special, values) and remove the linked reference from showing in the current s/s. Any ideas how to do this instead of me changing each linked reference? Thanks in advance! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 97-remove link but keep data
Im not very technically minded so, I tried the simple yet effective approach
of PASTE SPECIAL, VALUES for the whole s/s. This did the trick superbly! Thanks for your help. "Van" wrote: Hi guys, I have a pre-existing excel 97 s/s which has links to other s/s's. I would like to keep the data only (like paste-special, values) and remove the linked reference from showing in the current s/s. Any ideas how to do this instead of me changing each linked reference? Thanks in advance! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 97-remove link but keep data
But that did change all the formulas to values, right. If that's not a problem,
then this seems like a perfect solution. Van wrote: Im not very technically minded so, I tried the simple yet effective approach of PASTE SPECIAL, VALUES for the whole s/s. This did the trick superbly! Thanks for your help. "Van" wrote: Hi guys, I have a pre-existing excel 97 s/s which has links to other s/s's. I would like to keep the data only (like paste-special, values) and remove the linked reference from showing in the current s/s. Any ideas how to do this instead of me changing each linked reference? Thanks in advance! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How To: Link worksheet data to pre-existing chart tables | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| I cannot remove a link in excel 2000? | Excel Worksheet Functions | |||
Linear Mode
