Repeates 'Value' not formula when fill function used

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

Niek Otten

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