Refresh Calculations

Alka Bajaj

New Member
Joined
Apr 5, 2011
Messages
44
Hi Expert,

I have a workbook, with many worksheets & formula within. At times when it is saved as some different version or opened in some other system,all the formula cells are updated as "0", . Tried using F9 to update the calculations but it doesnt work, and I have to individually go and enter each cell to refersh the formula.

Is there any way, to automatically refresh the calculation, evrytime workbook is opened or data source is refreshed.

Appreciate your advice.

Thanks,
Regards,
Alka
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

anglais428

Well-known Member
Joined
Nov 23, 2009
Messages
634
Office Version
  1. 2016
Platform
  1. Windows
Do you have auto calculations switched off? GO to Office button - excel options - formulas - look at workbook calculation - ensure this is automatic
 

anglais428

Well-known Member
Joined
Nov 23, 2009
Messages
634
Office Version
  1. 2016
Platform
  1. Windows
what formula's do you have? If for example you have any linked to another unopened workbook this could be the reason
 

Alka Bajaj

New Member
Joined
Apr 5, 2011
Messages
44
I am using countifs and sumproduct. These formula refers across the sheets in the same workbook.
 

anglais428

Well-known Member
Joined
Nov 23, 2009
Messages
634
Office Version
  1. 2016
Platform
  1. Windows
Could you perhaps post a formula and the result? Are the cells your formula is based on static? Or do they contain any external links?
 

Watch MrExcel Video

Forum statistics

Threads
1,126,922
Messages
5,621,620
Members
415,847
Latest member
AlpinoHirsch

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top