Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Break a link/formula but keep the data?
Is there any way to break (get rid of) the formulas on a sheet (which the
data from another sheet to populate this sheet) but keep the data? |
#2
|
|||
|
|||
select all such cells.
do edit =Copy then immediatly do Edit=Paste special and select just Values. This will do what you describe. -- Regards, Tom Ogilvy "Task Lead Nicole" wrote in message ... Is there any way to break (get rid of) the formulas on a sheet (which the data from another sheet to populate this sheet) but keep the data? |
#3
|
|||
|
|||
I receive a file where the sender used a link to his own source, but he does
not send me his source. When I open the file I can see the value of the linked data, but when I click either "update" or "don't update" the linked cell become "#NAME?" and the value disappear. How can I keep the value as when the file was just opened? "Tom Ogilvy" wrote: select all such cells. do edit =Copy then immediatly do Edit=Paste special and select just Values. This will do what you describe. -- Regards, Tom Ogilvy "Task Lead Nicole" wrote in message ... Is there any way to break (get rid of) the formulas on a sheet (which the data from another sheet to populate this sheet) but keep the data? |
#4
|
|||
|
|||
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/groups?thre...GP11.phx .gbl Maybe it'll work ok for you. Trang wrote: I receive a file where the sender used a link to his own source, but he does not send me his source. When I open the file I can see the value of the linked data, but when I click either "update" or "don't update" the linked cell become "#NAME?" and the value disappear. How can I keep the value as when the file was just opened? "Tom Ogilvy" wrote: select all such cells. do edit =Copy then immediatly do Edit=Paste special and select just Values. This will do what you describe. -- Regards, Tom Ogilvy "Task Lead Nicole" wrote in message ... Is there any way to break (get rid of) the formulas on a sheet (which the data from another sheet to populate this sheet) but keep the data? -- Dave Peterson |
#5
|
|||
|
|||
Thank you for your reply. But I do as instructed in that group and it does
not work. Can you be more detailed? "Dave Peterson" wrote: 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/groups?thre...GP11.phx .gbl Maybe it'll work ok for you. Trang wrote: I receive a file where the sender used a link to his own source, but he does not send me his source. When I open the file I can see the value of the linked data, but when I click either "update" or "don't update" the linked cell become "#NAME?" and the value disappear. How can I keep the value as when the file was just opened? "Tom Ogilvy" wrote: select all such cells. do edit =Copy then immediatly do Edit=Paste special and select just Values. This will do what you describe. -- Regards, Tom Ogilvy "Task Lead Nicole" wrote in message ... Is there any way to break (get rid of) the formulas on a sheet (which the data from another sheet to populate this sheet) but keep the data? -- Dave Peterson |
#6
|
|||
|
|||
Now it works. Thanks.
"Trang" wrote: Thank you for your reply. But I do as instructed in that group and it does not work. Can you be more detailed? "Dave Peterson" wrote: 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/groups?thre...GP11.phx .gbl Maybe it'll work ok for you. Trang wrote: I receive a file where the sender used a link to his own source, but he does not send me his source. When I open the file I can see the value of the linked data, but when I click either "update" or "don't update" the linked cell become "#NAME?" and the value disappear. How can I keep the value as when the file was just opened? "Tom Ogilvy" wrote: select all such cells. do edit =Copy then immediatly do Edit=Paste special and select just Values. This will do what you describe. -- Regards, Tom Ogilvy "Task Lead Nicole" wrote in message ... Is there any way to break (get rid of) the formulas on a sheet (which the data from another sheet to populate this sheet) but keep the data? -- Dave Peterson |
#7
|
|||
|
|||
Second time is the charm.
Glad you got it working. Trang wrote: Now it works. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Is there a way to get an auto page break as data changes in Excel. | Excel Discussion (Misc queries) | |||
How can I insert a vertical column break between data to create a. | Excel Worksheet Functions |