Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 29th 04, 03:42 PM
Luke MacNeil
 
Posts: n/a
Default Formulas stop calculating at random times when editing a few spreadsheets.

"Frank Kabel" wrote in message ...
Hi
check if automatic calculation is enabled ('Tools - Options -
Calculate')


Yes, it is set to automatic.
I have him checking to see the setting at the next time the calculations hiccup.


--
Regards
Frank Kabel
Frankfurt, Germany

"Luke MacNeil" schrieb im Newsbeitrag
...
Greetings,

There are few spreadsheets that one of my users works on that have a
rather odd error. One in particular is filled with simple
addition/subtraction formulas. Quantity/Net Price/Total Price type
fields. He uses the spreadsheet daily and is constantly cutting and
pasting into and out of it.. so it functions sort of like a

calculator.

Sometimes he will be cutting and pasting into a field, say the

quantity
field, but the other fields wont update.

I've already reinstalled office 2000, re-applied all service
packs/updates both to office and windows, and actually rebuilt his
entire machine from an image.

Still the same problem. I'd really like to get to the bottom of this

and
get him back running with some stability.

Any help would be appreciated.

Luke MacNeil
A+,Net+,Linux+,MCP,MCSA


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet

News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World!
100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---


  #2   Report Post  
Old November 29th 04, 10:00 PM
Luke MacNeil
 
Posts: n/a
Default

Indeed. When he opened up the workbook this afternoon it was set to manual.
Hopefully saving it as automatic will solve the problem. Thanks for your help.

(Luke MacNeil) wrote in message . com...
"Frank Kabel" wrote in message ...
Hi
check if automatic calculation is enabled ('Tools - Options -
Calculate')


Yes, it is set to automatic.
I have him checking to see the setting at the next time the calculations hiccup.


--
Regards
Frank Kabel
Frankfurt, Germany

"Luke MacNeil" schrieb im Newsbeitrag
...
Greetings,

There are few spreadsheets that one of my users works on that have a
rather odd error. One in particular is filled with simple
addition/subtraction formulas. Quantity/Net Price/Total Price type
fields. He uses the spreadsheet daily and is constantly cutting and
pasting into and out of it.. so it functions sort of like a

calculator.

Sometimes he will be cutting and pasting into a field, say the

quantity
field, but the other fields wont update.

I've already reinstalled office 2000, re-applied all service
packs/updates both to office and windows, and actually rebuilt his
entire machine from an image.

Still the same problem. I'd really like to get to the bottom of this

and
get him back running with some stability.

Any help would be appreciated.

Luke MacNeil
A+,Net+,Linux+,MCP,MCSA


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet

News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World!
100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

  #3   Report Post  
Old November 29th 04, 11:30 PM
Gord Dibben
 
Posts: n/a
Default

Luke

Hopefully saving it as automatic will solve the problem.


Not necessarily........

If you're wondering how it got switched to "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

To ensure that calculation mode is always set to Auto for that particular
workbook, you could place code in a Workbook_Open sub in ThisWorkbook module.

Private Sub WorkBook_Open()
Application.Calculation = xlAutomatic
End Sub

Or have the code in your Personal.xls which opens with each session of Excel.

Gord Dibben Excel MVP


On 29 Nov 2004 13:00:52 -0800, (Luke MacNeil) wrote:

Indeed. When he opened up the workbook this afternoon it was set to manual.
Hopefully saving it as automatic will solve the problem. Thanks for your help.

(Luke MacNeil) wrote in message . com...
"Frank Kabel" wrote in message ...
Hi
check if automatic calculation is enabled ('Tools - Options -
Calculate')


Yes, it is set to automatic.
I have him checking to see the setting at the next time the calculations hiccup.


--
Regards
Frank Kabel
Frankfurt, Germany

"Luke MacNeil" schrieb im Newsbeitrag
...
Greetings,

There are few spreadsheets that one of my users works on that have a
rather odd error. One in particular is filled with simple
addition/subtraction formulas. Quantity/Net Price/Total Price type
fields. He uses the spreadsheet daily and is constantly cutting and
pasting into and out of it.. so it functions sort of like a

calculator.

Sometimes he will be cutting and pasting into a field, say the

quantity
field, but the other fields wont update.

I've already reinstalled office 2000, re-applied all service
packs/updates both to office and windows, and actually rebuilt his
entire machine from an image.

Still the same problem. I'd really like to get to the bottom of this

and
get him back running with some stability.

Any help would be appreciated.

Luke MacNeil
A+,Net+,Linux+,MCP,MCSA


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet

News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World!
100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---


  #4   Report Post  
Old November 30th 04, 04:21 PM
[email protected]
 
Posts: n/a
Default

Thank you very much for your reply.
I'll definatly remember the Sub code.

- Luke


Gord Dibben wrote:
Luke

Hopefully saving it as automatic will solve the problem.


Not necessarily........

If you're wondering how it got switched to "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

To ensure that calculation mode is always set to Auto for that

particular
workbook, you could place code in a Workbook_Open sub in ThisWorkbook

module.

Private Sub WorkBook_Open()
Application.Calculation = xlAutomatic
End Sub

Or have the code in your Personal.xls which opens with each session

of Excel.

Gord Dibben Excel MVP


On 29 Nov 2004 13:00:52 -0800, (Luke MacNeil) wrote:

Indeed. When he opened up the workbook this afternoon it was set to

manual.
Hopefully saving it as automatic will solve the problem. Thanks for

your help.

(Luke MacNeil) wrote in message

. com...
"Frank Kabel" wrote in message

...
Hi
check if automatic calculation is enabled ('Tools - Options -
Calculate')


Yes, it is set to automatic.
I have him checking to see the setting at the next time the

calculations hiccup.


--
Regards
Frank Kabel
Frankfurt, Germany

"Luke MacNeil" schrieb im

Newsbeitrag
...
Greetings,

There are few spreadsheets that one of my users works on that

have a
rather odd error. One in particular is filled with simple
addition/subtraction formulas. Quantity/Net Price/Total Price

type
fields. He uses the spreadsheet daily and is constantly

cutting and
pasting into and out of it.. so it functions sort of like a
calculator.

Sometimes he will be cutting and pasting into a field, say the
quantity
field, but the other fields wont update.

I've already reinstalled office 2000, re-applied all service
packs/updates both to office and windows, and actually rebuilt

his
entire machine from an image.

Still the same problem. I'd really like to get to the bottom

of this
and
get him back running with some stability.

Any help would be appreciated.

Luke MacNeil
A+,Net+,Linux+,MCP,MCSA


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure

Usenet
News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the
World!
100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via

Encryption =---



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:26 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017