Problems with MS Excel

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
Dave1142
Newbie
Posts: 6
Joined: Wed Dec 19, 2012 6:21 pm

Problems with MS Excel

Post by Dave1142 » Wed Sep 21, 2016 12:39 am

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

User avatar
Marcus Tettmar
Site Admin
Posts: 7393
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Re: Problems with MS Excel

Post by Marcus Tettmar » Wed Sep 21, 2016 7:31 am

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
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

Dave1142
Newbie
Posts: 6
Joined: Wed Dec 19, 2012 6:21 pm

Re: Problems with MS Excel

Post by Dave1142 » Wed Sep 28, 2016 3:55 pm

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.

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts