1
I have an inherited spreadsheet that I really don't want to rebuild at the moment. It's a simple small workbook that is small (< 200 rows that don't even reach to AA) and does nothing more than calculate some totals within the same worksheets. No macros, no external data sources, nothing beyond basic formatting of dates, numbers and strings.
I see importing data from CSV/text has created many many workbook connections over time, but even if I delete them all (there were hundreds) it makes no difference in performance.
Even clicking to simply change focus from cell to cell takes 10+ seconds, adorned by the spinning cursor and (Not Responding) appending to the title bar and the application locking up. The program seems to "recover" every time, but efficiency of editing this file is obviously seriously handicapped.
All other files seem fine in Excel, and other programs have no apparent performance issues. I see Excel is chewing up CPU but I'm not sure how to narrow down what process or service is "clashing" with Excel. I tried the same file on other computers and performance is fine. If I turn off all start-up services and run only Excel, performance is restored... until I start using other programs and then it bogs down again.
At this point, I would entertain almost any idea, theory or suggestion that helps pinpoint, solve or work around the issue.
Tomorrow I am going to try within a VM, and see if it has the same issue there.
I'll scan for bad sectors and see what I get. Are you thinking disk defrag? This may be a stupid question, but if I choose to "save as", give it a different name and save it in another location, would it not physically live somewhere else? – Dallas – 2013-11-09T18:59:50.693
No - not a defrag. Bad sectors can arise from normal wear and tear or other causes like power off shut downs. Just search google for 'fixing bad sectors', there are lots of how to articles. If there are bad sectors then there may be many of them - saving in another folder may not help you. – Code Uniquely – 2013-11-10T09:28:07.017
No errors or bad sectors. It's a new machine, so I was hoping not. – Dallas – 2013-11-13T02:06:41.577
OK - What happens if you cut the cells from the Sheet and paste them into a new Excel File. – Code Uniquely – 2013-11-13T08:47:46.683
Tried and there was no difference. I pasted values only into a new file, and added formatting and column totals. This new spreadsheet behaves normally. It's a workaround, but I would still like to determine what the issue is. – Dallas – 2013-11-14T18:43:25.753
1Well you've made a start, You have a sheet that works normally and one that works is an odd fashion. It something to do with the formulae on the sheet, because values only works fine. Save the new one as a template. Cut and paste half the broken sheet over the new one and see its its broken. If not the error is in the other half. If its broken the error is in the half you pasted. Reload the working version and closing in by halving the amount you paste until you get the rows / cells that are causing your problem. Then you can investigate further from there. – Code Uniquely – 2013-11-15T05:11:54.727
Was able to narrow it down to three (but not all) summed columns. Simple sum at the bottom, nothing fancy. Suspect some copy and paste remnant from Word to Excel, but I just don't see anything. In Word you can choose "Show/Hide" to show some hidden formatting, but I don't see that same functionality in Excel. – Dallas – 2013-12-11T03:35:00.703
On the formulas tab you should have "Trace Precedents", "Trace Dependants" and "Show Formulas" - these may help .. – Code Uniquely – 2013-12-11T08:10:17.710