Hi guys,
I've copied an excel file which has macros. The sheets in that file have formulas linked to external files, however when I click the button "enable content" in the security warning, the formulas are replaced by values.
However, if I change the name of the file the formulas will be back since the active content is disabled again.
I guess this is some bug, but do you know some way to solve this problem in a way I can keep the formulas and have the active content at same time.
Thanks guys.
Bookmarks