Can't find why my spreadsheet doesn't calculate

Gman43

New Member
Joined
Oct 10, 2002
Messages
2
Hi,
When I open my spreadsheet I have a calculate message which appears on the status bar. My file is set to auto calc, so I can't figure out what is causing this? I don't get a circular reference or anything like that. I can't manully calculate the spreadsheet either. Is there any way to find out what is not calculating?
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hello: Gman43

Some things to check

--Is the problem only in this worksheet?
--Did you invoke the circular reference request to check if you have one?
--Are there any references outside this workbook? Possibly another file being open by another network user?
--Do you have any macros running that may be hung up?

I'll try to think of some others...

pll
This message was edited by plettieri on 2002-10-11 15:25
 

Gman43

New Member
Joined
Oct 10, 2002
Messages
2
Thanks for the tips plettieri. Didn't seem to find anything that worked. The calculate problem is only for this spreadsheet, but exsits for all the worksheets within. I can't even pinpoint which worksheet it is. This spreadsheet does reference other spreadsheets, but none of them are being shared. My macros all look okay.
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
maybe to narrow it down....try copying one worksheet in to fresh workbook, one worksheet at a time to see which one might be causing the problem...

pll
 

MAK

New Member
Joined
Oct 10, 2002
Messages
1
I have had that same problem on our network at the office but as soon as I saved it to my hard drive everything calculated. I think it is a memory issue.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,038
Messages
5,856,980
Members
431,843
Latest member
Malahhai

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