| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 recalc issue | Excel Discussion (Misc queries) | |||
| Why does an Excel Recalc cause traffic over Network ? | Excel Discussion (Misc queries) | |||
| Excel auto recalc is occuring with no change to data. Help! | Excel Discussion (Misc queries) | |||
| Run recalc until a specified vaule is reached. | Excel Discussion (Misc queries) | |||
| Automatic Recalc | Excel Worksheet Functions | |||
Linear Mode
