Excel 2007 - Recalc or NOT

A

AuldMannie

I have a workbook which has data passed from Access 2007 - that works
I do however need tp Recalc the spreadsheet after new data is passed. F9
seems to have zero effect. Have I screwed something up? If I delete a formula
and re enter it the calculation in that cell is perfect but with a few
hundred cells nae exactly fit I need! I need the entire workbook to
recalculate itself? I have tried manual recalculate - NOTHING. Have I screwed
up the workbook?
 
T

Tyro

Ctrl+Shift+Alt+F9 will force a complete reevaluation of all formulas and
will recalculate the workbook.

Tyro
 
A

AuldMannie

Thanks a lot. Having to depress that number of keys brings back memories of
using single 80 column card punch for program fixes!
 

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

cell does not recalc 3
Questions about Strange ReCalc Behavior 2
Removing "Calculate" Promp - Excel 2000 3
Manual calculation of calculated items in multiple pivottables 2
Recalculation does not work 8
How to tell Excel to recalc, unconditionally, now? 2
User Function Not Recalculating 5
formula recalculation in Excel 2003 - oddity? 3

Top