Repeates 'Value' not formula when fill function used

  • Thread starter Thread starter Ryan M
  • Start date Start date
R

Ryan M

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...
 
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!): Tools>Options>Calculation tab, check Automatic.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


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