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...

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...