Saving Workbooks with a lot of formulas

F

Frans

I have a workbook that have 15000 rows and 10 columns with 2 that have
Vlookups in them.
When saving it takes very long what is wrong?
I seems as if it is recalculating the formulas but I have switched the
recalculating off under options. If i spesial paste the formulas to values
it saves as normal.
How can i get the saving faster?
 

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

Word 2010: trouble saving font/size 9
share and merge workbooks 0
Print A For (docm), Send Email Attachment And Close For Without Saving 2
How do I keep formulas for being lost when saving in 2007? 4
Formulas saving as values 3
Sharing workbooks limitations - Merged Cells 12
File size too big 1
PivotCharts and recalculating workbooks 1

Top