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?
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,143
Messages
5,599,975
Members
414,354
Latest member
Flaxarn

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