Easily convert all formulas in 3d spreadsheet to values?

G

Guest

I have a large Excel 3-D workbook with 40 sheets, each with multiple complex
formulas.
At the end of each month I archive the sheet and would like to convert the
formulas into values to reduce the size of the workbook.
Can this be done in a few easy steps, as I don't want to copy and special
paste as values 40 times over?

Thanks
 
G

Guest

Hi

Group the sheets first, then select all of the cells on the visible sheet
(Ctrl+A) and Paste Special/Values.

Don't forget to ungroup the sheets after!

Andy.
 
G

Guest

Record a Macro (Tools>Macro>Record...) that copies and PasteSpecials each
sheet. Add a hot key (like Ctrl-V) to convert them all to values. Then all
you have to do is press your hot key.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert to Values 2
Formulas spontaneously convert to numbers 4
Convert all formulas to values 8
replace all formulas with values in multiple worksheets 5
Can you copy multiple tabs from formulas to values w/o paste spec? 2
Copying Excel formulas from one Workbook to another 3
REMOVING WORKBOOK'S ALL FORMULAS 3
Need to Speed Up A Code 2

Top