Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a spreadsheet where the calculate alert is showing down at the bottom
of the screen. I have calculations set to automatic in the options tab, but it still shows up. Why is that, and is there something I can do that would help clear that? The issue is bigger than this, but I figured I'd better keep it simple to start. Sean |
#2
![]() |
|||
|
|||
![]() Sean, have a look here, http://www.decisionmodels.com/calcsecretsf.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Sean Grier" <Sean wrote in message ... I have a spreadsheet where the calculate alert is showing down at the bottom of the screen. I have calculations set to automatic in the options tab, but it still shows up. Why is that, and is there something I can do that would help clear that? The issue is bigger than this, but I figured I'd better keep it simple to start. Sean |
#3
![]() |
|||
|
|||
![]()
Thanks, Paul. I had iterations turned on. Turning that off showed me that I
had too many decision trees for the spreadsheet to figure. Turns out I didn't need as many as I thought, so that helped lead me to clean up the spreadsheet. But as I said in my original post - this issue is manifold - I still have an issue with the spreadsheet not saving all the conditional formatting. When I try to save the file, it gives me a "Excel could not save all the data and formatting you recently added to Book1.xls" error. If I go ahead and hit OK to that error, it saves the file, but I loose about 75% of the conditional formatting in those cells that had it. I've tried copying the data to another spreadsheet (copy-paste values), then re-conditionally formatting the data, and when I get to a certain number of cells that have CF, it won't save any more (I start getting the error again). Weird stuff. I wonder if there's a limit to this conditional formatting I'm able to utilize. I've attempting 256 lines with 16 columns for a total of less than 1000 cells total. Sean "Paul B" wrote: Sean, have a look here, http://www.decisionmodels.com/calcsecretsf.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Sean Grier" <Sean wrote in message ... I have a spreadsheet where the calculate alert is showing down at the bottom of the screen. I have calculations set to automatic in the options tab, but it still shows up. Why is that, and is there something I can do that would help clear that? The issue is bigger than this, but I figured I'd better keep it simple to start. Sean |
#4
![]() |
|||
|
|||
![]()
Also:
http://support.microsoft.com/default.aspx?scid=243495 XL: Calculate Message Remains in Status Bar If 65,536 Formula References Sean Grier wrote: I have a spreadsheet where the calculate alert is showing down at the bottom of the screen. I have calculations set to automatic in the options tab, but it still shows up. Why is that, and is there something I can do that would help clear that? The issue is bigger than this, but I figured I'd better keep it simple to start. Sean -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tabs accross of bottom of sheet are not showing | Excel Discussion (Misc queries) | |||
Calculate | Excel Discussion (Misc queries) | |||
How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
Not able to calculate. | Excel Worksheet Functions | |||
"Calculate" note at bottom of my screen? | Excel Worksheet Functions |