Excel Recalc All except one sheet

D

dhoorens

Joined
Jan 7, 2009
Messages
3
Reaction score
0
Hi
I have an excel file with ~20 sheets
Approx runtime for recalc wkb is 1 minute
One of those sheets is very slow (90% of total recalc time), and I don't want it to be recalcaltuled when I push F9. Is it possible? (I'm okay with a vba solution via a command button)
Solutions like:
* Export sheet in another wkb
* Copy paste values of this sheet
are not acceptable :)

Tks
David
 

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

Recalc Time 5
UDF recalc problem between sheets 7
Excel, assign cells in multiple worksheets from one sheet 1
Questions about Strange ReCalc Behavior 2
Excel & Reuters Power Plus Pro 3
Many to One (Excel sheet) 4
Converting Excel 2007 sheet back down to Excel 2003 1
Delete all sheets except three 3

Top