How to force closed excel workbook to make calculations?

[pruleone]

Hy,

maybe anyone had somekind of problem and knows good solution


Problem is that closed excel workbook doesn't to calculations.
I moved calculations from one workbook to an other workbook because maybe in the future I need to make some changes in calculation sheets.

As this main workbook is used by lots of people and they all can save it in theid hard drive so no changes would aply to those workbooks which have already saved.
So I first thought I will remove this problem by moveing sheets where I would change something to other workbook. But now I have a new problem - all those calculations do not work when second workbook is closed.

As user of this main workbook aren't very good in excel, I can't also say to them that you need to open every time two workbooks.


So to come back to beginning - maybe someone had this kind of problem and solved it differently then just moveing all those calculation sheets back to main workbook.

Maybe somekind of macro or could help, that would force second workbook to do those calculation after doing certain thing in main workbook.

 

[SkipVought]

Hi,

You can open that workbook in the Workbook Open event and force it to calcuate. Please post VBA questions in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}