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

Tyro

"AuldMannie" wrote in message
...
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?