ctrl alt f9 doesn't do anything.<[email protected]>

Y

Yirmin

I've got the same problem as the other guy with the very large work book that only recalcs when you close and reopen it. I've tried ctrl alt f9, I've tried ctrl shift alt f9 and the don't do a thing. Is there something that has to be turned on in excel to enable this?

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
D

Dave Peterson

Maybe you could do this:

select all the worksheets
select a single cell
edit|Replace
what: = (equal sign)
with: =
replace all
Ungroup the sheets
 

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

F9, Shift+F9, Ctrl+Alt+F9 etc 3
Ctrl-a, F9 doesn't work to update all fields including TOC 6
difference between Alt-Control-Shift-F9 and Ctrl-H Replace = with 2
Recalculation does not work 8
Recalc problem - and does not respond to Ctrl-Alt-F9 1
Calculations may not occur in an Excel 1
Excel Date Picker problem 0
Application.Volatile False doesn't work with Application.Run? 1

Top