| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeates 'Value' not formula when fill function used
I have a spreadsheet A (Basic uses all simple formula all contained within
the once file)... ever since I opened spreadsheet B and enabled the Macros that sheet contains spreadsheet A no longer works correctly. Now when I attempt to use the fill function values are copied instead of the adjusted formula being applied to the cells... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeates 'Value' not formula when fill function used
Your macro probably sets Calculation to Manual. This an Excel-wide setting; it applies to all workbooks open in that instance of
Excel. To correct (note that it will then apply to B too!): ToolsOptionsCalculation tab, check Automatic. -- Kind regards, Niek Otten Microsoft MVP - Excel "Ryan M" <Ryan wrote in message ... |I have a spreadsheet A (Basic uses all simple formula all contained within | the once file)... ever since I opened spreadsheet B and enabled the Macros | that sheet contains spreadsheet A no longer works correctly. Now when I | attempt to use the fill function values are copied instead of the adjusted | formula being applied to the cells... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| increment an integer in a formula with the fill function | Excel Worksheet Functions | |||
| Using Data Fill function to copy a Countif formula | Excel Worksheet Functions | |||
| Using Data Fill function to copy a Countif formula | Excel Worksheet Functions | |||
| color fill cells based on IF function or formula | Excel Worksheet Functions | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
Linear Mode
