LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Excel won't calculate

I have a spreadsheet that originally worked with the formulas using basic SUM
and IFSUM. I have posted it to my web site, with protection and only left
certain cells open for editing. I recently discoverd that it is no longer
calculating. I have opened it, removed all protection, unlocked all cells
and redone some of the SUM calcs, but it still won't calc when I change the
values in the cells that are in the SUM range.

Years ago, Excel had problem if you copied the formulas too many times, it
stopped recalculating, but I am not sure what the issue with this sheet is.

I have even run the formula evaluation. When I change a single value in the
column from 0 to 1 and evaluate, the SUM still appears as 0.

Help!!!
 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I calculate Ker and Kei using Excel Binder Excel Worksheet Functions 2 March 2nd 09 06:49 AM
Excel Won't Calculate davem97132 Excel Worksheet Functions 1 June 5th 08 01:51 AM
Activesheet.Calculate failing to calculate Daniel Bonallack Excel Programming 2 October 11th 06 03:16 AM
Range.calculate debug, Excel 2000 VBA compatability with Excel XP Bill Excel Programming 0 August 23rd 04 12:09 PM
Macro that hide or unhide and not calculate or calculate Jonsson Excel Programming 1 August 19th 03 04:22 PM


All times are GMT +1. The time now is 06:25 AM.

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

About Us

"It's about Microsoft Excel"