SOLVED

copy

New Contributor
I first open an excel file and I do a formula like multiply Cell H *100 and copy down the formula, it gives me same value as cell H1.  However, if I save the sheet l realized it refreshes to correct value down the copied cells H2, H3, H4 etc.     Is this working as designed ?
4 Replies
best response confirmed by nohanna (New Contributor)
Solution

@nohanna 

Hi

Your Excel is probably currently configured to calculate "on-demand" (Manual). No idea what version you run nor on which platform (Windows, Mac...). On Excel 365/Windows:

- Go to Formulas tab

- Calculation Options > Automatic

Demo.png

 

Kind reminder - In Welcome to your Excel discussion space!:
Please include the following info to help others answer your question
- Device and OS platform (Windows, Mac, ...)
- Excel product name and version number
...

our formula should =H1*100 and the fill down,,, you get expected results!!
Thank you so much Lz. ! . Your answer solved my issue
You're welcome. Glad I could help & Thanks for posting back. Take care...