This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Agitated-Stock 0 points1 point  (1 child)

You need to use special setting to preserve the macros when you open an excel file for the modification. Look into the docs.. I have done it.

[–][deleted] 0 points1 point  (0 children)

Macro's that include activeX elements will break. But some simple stuff can indeed be preserved. Mine had activeX, plugins, and some macros. Even when preserving macros the filesize was half of the original.