I have been noticing odd problems in MS Excel. When I have fairly large spreadsheets I notice Excel has calculation errors for example I create a skip sheet with the match formula. All of the calculations come out correct except for one line for about 25 cells. I double check everything in the formula including the cell format and re-enter the formula. Nothing changes and excel still thinks its correct with no errors. I recreate the whole sheet in a new work book and find similar errors in different spots on the spreadsheet. I have changed computers and re create not copy just to find errors once again in different places and in different numbers of cells. I have found this in Excel 2002, 2003, 2007 and 2010 in different workbooks and on different machines AMD and Intel each with different specs. Since the cell errors do not move around once the sheet is created and reopened I find myself using Macro Scheduler a lot to correct excels miss calculations. Has anyone else found calculation errors using any of the excel versions?
Dave
Problems with MS Excel
Moderators: Dorian (MJT support), JRL
- Marcus Tettmar
- Site Admin
- Posts: 7393
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Re: Problems with MS Excel
Have you tried refreshing the sheet? Maybe it just needs a refresh. Have you googled it / checked Microsoft's forums? E.g/:
http://answers.microsoft.com/en-us/msof ... be3?auth=1
http://answers.microsoft.com/en-us/msof ... be3?auth=1
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
Re: Problems with MS Excel
I tried Microsoft's help and forums. They indicate there is something wrong with the formulas. So far I have not found any error and excel says everything's ok as far as error checking goes(did do refresh). The only thing I have found so far is an article that said 88 percent of all spreadsheets contain errors as found by a university study. Not much for a solution to the problem though. It is not such a problem to where excel is unusable. I just double check results and do not believe any information a spreadsheet gives without double checking the math first.