Automatically save complete workbook, without formulas, to a new location

[Drease]

Hi,

Many months ago at work I started creating an Excel document, which over the months grew and grew into a huge beast laden with all kinds of excel formula's.

Over time, my (not so ICT adept) colleagues started seeing the benefits of all the data within the file and many of them are now consulting it on a daily basis. My colleagues don't need the formula's and never change anything, they just consult it.

Also, when they currently open the document, it takes between 30 and 90 seconds just to load because of all the calculations within.

So I was thinking: Wouldn't it be nice to have a button to save the document to a specific location (shared location where my coworkers usually find it); and that the saved file is data + formatting only?

Could this be achieved with a custom button or hotkey launching a VBA application? I know some VBA, but not nearly enough to quickly figure this out on my own.

Anyone willing to help? I would be most grateful!

Thanks in advance!

[alansidman]

https://excelribbon.tips.net/T012382..._Formulas.html

[Drease]

Hi Alan,

I had found that page too, but the solution there doesn't:

• Create a new file in a different location
• copy all worksheets
• copy formatting

Thank you anyway.

[alansidman]

See if this works for you.

Please Login or Register  to view this content.

Put a Command Button in the file and link this code to it.

[Drease]

Dear Alan,

Thank you for your help. This is what I ended up with:

Please Login or Register  to view this content.