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
Excel does not accept text format! 0
Excel 2003 recalc issue 0
Manual calculation of calculated items in multiple pivottables 2
Why does an Excel Recalc cause traffic over Network ? 0
2010 MultiThreadedCalculation Incompatible with Range.Calculate 0
Excel 2007 won't recalculate unless I turn off or re-apply auto filter 0
How to tell Excel to recalc, unconditionally, now? 2

Top