copy

[nohanna]

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 ?

[#2 · Accepted 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

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

[#3]

our formula should =H1*100 and the fill down,,, you get expected results!!

[#4]

Thank you so much Lz. ! . Your answer solved my issue :)

[#5]

You're welcome. Glad I could help & Thanks for posting back. Take care...