Excel 2007 - Recalc or NOT
 

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?

Excel 2007 - Recalc or NOT
 

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?

Excel 2007 - Recalc or NOT
 

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

"Tyro" wrote:

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?