Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula refresh
The problem i am having is i have a excel file with sum formulas entered.
When i enter in a value and hit the tab or enter key the formula will not add that value to the total. The only way to get the data to populate is to hit the F9 key or click the Save button and the totals appear. Am i missing something? I would like the user to enter in data then tab to the next column and populate the entered data automatically. Any help would greatly appreciated. TIA Marcus |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula refresh
Tools/ Options/ Calculation
Set it to Automatic, not Manual. -- David Biddulph "Marcus" wrote in message ... The problem i am having is i have a excel file with sum formulas entered. When i enter in a value and hit the tab or enter key the formula will not add that value to the total. The only way to get the data to populate is to hit the F9 key or click the Save button and the totals appear. Am i missing something? I would like the user to enter in data then tab to the next column and populate the entered data automatically. Any help would greatly appreciated. TIA Marcus |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula refresh
Go to
Tools-Options, Calculation Select automatic. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Marcus" wrote: The problem i am having is i have a excel file with sum formulas entered. When i enter in a value and hit the tab or enter key the formula will not add that value to the total. The only way to get the data to populate is to hit the F9 key or click the Save button and the totals appear. Am i missing something? I would like the user to enter in data then tab to the next column and populate the entered data automatically. Any help would greatly appreciated. TIA Marcus |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula refresh
From the Main Menu Bar select:
Tools- Options From the Calculation Tab Click on Automatic, then save your file. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Marcus" wrote: The problem i am having is i have a excel file with sum formulas entered. When i enter in a value and hit the tab or enter key the formula will not add that value to the total. The only way to get the data to populate is to hit the F9 key or click the Save button and the totals appear. Am i missing something? I would like the user to enter in data then tab to the next column and populate the entered data automatically. Any help would greatly appreciated. TIA Marcus |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula refresh
Make sure calculation is set to automatic. ToolsOptionsCalculation
tabAutomaticOK -- Biff Microsoft Excel MVP "Marcus" wrote in message ... The problem i am having is i have a excel file with sum formulas entered. When i enter in a value and hit the tab or enter key the formula will not add that value to the total. The only way to get the data to populate is to hit the F9 key or click the Save button and the totals appear. Am i missing something? I would like the user to enter in data then tab to the next column and populate the entered data automatically. Any help would greatly appreciated. TIA Marcus |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula refresh
Hi,
If you are using 2007 choose Formulas tab, Calculation group, Calculation Options, Automatic -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Marcus" wrote in message ... The problem i am having is i have a excel file with sum formulas entered. When i enter in a value and hit the tab or enter key the formula will not add that value to the total. The only way to get the data to populate is to hit the F9 key or click the Save button and the totals appear. Am i missing something? I would like the user to enter in data then tab to the next column and populate the entered data automatically. Any help would greatly appreciated. TIA Marcus |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula refresh
Good idea to save the file with calc mode set to automatic
BUT.......a warning. If a workbook with calc mode set to manual is the first opened workbook in a session, all subsequent workbooks opened will also be set to manual even if they were saved in automatic mode. You must be aware of this feature in all versions of Excel. Gord Dibben MS Excel MVP On Wed, 7 Jan 2009 10:13:00 -0800, Michael wrote: From the Main Menu Bar select: Tools- Options From the Calculation Tab Click on Automatic, then save your file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
Formula do not refresh automatically | Excel Discussion (Misc queries) | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) |