How do I break links to external data using macros. [closed]

asked 2012-08-26 16:29:16 +0200

Spunalien gravatar image

updated 2013-02-22 09:31:56 +0200

qubit gravatar image

I have a calc sheet that derives its original data from external sources prior to my using a macro to do all the manipulation. I manually break the links before running the macro(using edit:links works but it is the only manual process and it would be nice to eliminate a routine step). The last function the macro completes is saving the modified file, is there any way to either in the macro or in the save/save as process break the links to the source data?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by qubit
close date 2013-04-14 03:06:46.841771

Comments

Hi @Spunalien, Still looking for an answer here? Please let us know so we can resolve/close this question. Thanks!

qubit gravatar imagequbit ( 2013-03-21 10:24:49 +0200 )edit

I could answer this if you would reopen the question. I just solved the same problem.

user7610 gravatar imageuser7610 ( 2017-02-23 15:26:40 +0200 )edit

breaking a link with a macro could also be used to update a link with a macro? I would very much like to know/see your solution @user7610

staylorx gravatar imagestaylorx ( 2017-08-01 20:30:16 +0200 )edit