Strange Excel behaviour

[Corey]

I tried to use a workbook today that was previously working great.
It have macros and many formulas.
I found that the simple formulas were not working for some reason.
When i close the workbook, and re-open it the formulas have then calculated their result.

Also if i PrintPreview, the commandbuttons on the sheet move to the left side of the page.

What could be causing this?

How can i fix it?

Corey....

 

[Corey]

Found a little more.
The calculations work as soon as i Save the file also, but NOT until then.
Any idea's?

Corey




I tried to use a workbook today that was previously working great.
It have macros and many formulas.
I found that the simple formulas were not working for some reason.
When i close the workbook, and re-open it the formulas have then calculated their result.

Also if i PrintPreview, the commandbuttons on the sheet move to the left side of the page.

What could be causing this?

How can i fix it?

Corey....

 

[Chip Pearson]

The first thing I would test would be to ensure that calculation is set to
automatic. Go to the Tools menu, choose Options, then the Calculation tab.
There, ensure that automatic is selected. If it is manual and "Recalculate
before save" is checked, that you explain why you get a calc upon save.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

 

[Dave Peterson]

For the calculation problem:

Maybe: Tools|Options|calculation tab|make sure it's set to automatic

For the commandbuttons problem:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

But Jim Rech recently posted this:
This article is now obsolete. Since the 10/12/2004 security patch
there is no need to get a hotfix (although this article does not directly
mention this fix, it's in there).

http://support.microsoft.com/default.aspx?scid=kb;en-us;832332

But Myrna Larson (and others) posted that it didn't work for her in all her
workbooks.

 

[Corey]

Solved the caluc bit.
Somehow the Calulation was set to manual, instead of Automatic??

Still need to find out why the commnadbuttons move after print previewing though



I tried to use a workbook today that was previously working great.
It have macros and many formulas.
I found that the simple formulas were not working for some reason.
When i close the workbook, and re-open it the formulas have then calculated their result.

Also if i PrintPreview, the commandbuttons on the sheet move to the left side of the page.

What could be causing this?

How can i fix it?

Corey....

 

[Corey]

Thanks dave.
Twas the sp3 update that caused the problem.

Had to strangely set the buttons to MOVE and SIZE will cells for them to NOT move??

Strange setting, but it seems to be solving then problem.

Cheers

Corey....


For the calculation problem:

Maybe: Tools|Options|calculation tab|make sure it's set to automatic

For the commandbuttons problem:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

But Jim Rech recently posted this:
This article is now obsolete. Since the 10/12/2004 security patch
there is no need to get a hotfix (although this article does not directly
mention this fix, it's in there).

http://support.microsoft.com/default.aspx?scid=kb;en-us;832332

But Myrna Larson (and others) posted that it didn't work for her in all her
workbooks.

 

[Gord Dibben]

On the calculation issue.....................

Common problem......not yet fixed in 2007 version.

Tools>Options>Calculation can be Auto or Manual.

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g>


Gord Dibben MS Excel MVP