Home

Excel 2010 Not Responding

%3CLINGO-SUB%20id%3D%22lingo-sub-324131%22%20slang%3D%22en-US%22%3EExcel%202010%20Not%20Responding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-324131%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20work%20I%20do%20a%20variance%20report%20each%20month%20by%20copying%20the%20workbook%20from%20the%20previous%20month%2C%20clearing%20the%20old%20data%2C%20and%20copying%20and%20pasting%20new%20data%20downloaded%20from%20our%20accounts%20database.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHaving%20done%20that%20I%20copy%20and%20paste%20a%20couple%20of%20columns%20of%20data%20from%20the%20previous%20month%20into%20the%20new%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOver%20the%20last%20couple%20of%20months%20the%20workbook%20freezes%20and%20comes%20up%20%22not%20responding%22%20when%20I%20do%20this.%20Could%20this%20be%20a%20user%20error%20ie.%20could%20I%20have%20accidentally%20copied%20some%20formulas%20or%20something%20that%20I'm%20not%20aware%20of%3F%20If%20so%20how%20do%20I%20find%20out%20how%20I%20screwed%20up%3F%20Is%20there%20some%20sort%20of%20error%20check%20formula%20I%20can%20use%20or%20one%20that%20put%20highlight%20all%20formulas%20in%20the%20worksheet%20or%20something.....%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-324131%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%202010%20Not%20Reponding%20Issue%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-353203%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202010%20Not%20Responding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353203%22%20slang%3D%22en-US%22%3EIf%20you%20look%20(google)%20for%20%22delete%20unused%20styles%20Excel%22%20yu%20should%20be%20able%20to%20find%20a%20macro%20which%20does%20precisely%20that%20%3A-)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352738%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202010%20Not%20Responding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352738%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20new%20spread%20sheet%20has%20tons%20more%20than%20the%20previous.%26nbsp%3B%20Could%20this%26nbsp%3Bslow%20down%20excel%3F%26nbsp%3B%20what%20causes%20them%20to%20be%20created%3F%26nbsp%3B%20can%20I%20delete%20them%3F%26nbsp%3B%20how%20do%20I%20find%20what%20they%20reference%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-324188%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202010%20Not%20Responding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-324188%22%20slang%3D%22en-US%22%3EI%20expect%20your%20report%20has%20a%20long%20editing%20history%2C%20so%20all%20sorts%20of%20junk%20may%20have%20ended%20up%20in%20your%20file.%20Copying%20and%20pasting%20information%20from%20one%20workbook%20into%20another%20is%20a%20process%20that%20causes%20all%20sorts%20of%20potential%20issues.%20For%20example%2C%20on%20the%20home%20tab%2C%20click%20to%20expand%20the%20Cell%20Styles%20Gallery%20while%20you%20have%20a%20fresh%2C%20new%20workbook%20window%20open.%20Now%20do%20the%20same%20with%20your%20reporting%20file%20open%20and%20compare%20the%20appearance.%20It%20is%20not%20unlikely%20that%20you%20have%20gained%20a%20lot%20of%20custom%20styles%20with%20funny%20names%20like%20Normal%201%2C%20Normal%201%201%2C%20Normal%201%202%201%2C%20...%3CBR%20%2F%3EAlso%2C%20have%20a%20look%20at%20Name%20Manager%20(Formulas%20tab).%20Anything%20unexpected%20there%3F%20Finally%20(for%20this%20post%20anyway)%2C%20on%20the%20home%20tab%2C%20click%20the%20binoculars%20and%20choose%20%22Selection%20pane%22%2C%20check%20out%20how%20many%20objects%20are%20listed%20and%20whether%20that%20is%20expected.%20Make%20sure%20you%20select%20each%20worksheet%20to%20do%20this%20check.%3C%2FLINGO-BODY%3E
Highlighted
Brian5
Occasional Visitor

Hi

 

At work I do a variance report each month by copying the workbook from the previous month, clearing the old data, and copying and pasting new data downloaded from our accounts database.

 

Having done that I copy and paste a couple of columns of data from the previous month into the new workbook.

 

Over the last couple of months the workbook freezes and comes up "not responding" when I do this. Could this be a user error ie. could I have accidentally copied some formulas or something that I'm not aware of? If so how do I find out how I screwed up? Is there some sort of error check formula I can use or one that put highlight all formulas in the worksheet or something.....?

3 Replies
I expect your report has a long editing history, so all sorts of junk may have ended up in your file. Copying and pasting information from one workbook into another is a process that causes all sorts of potential issues. For example, on the home tab, click to expand the Cell Styles Gallery while you have a fresh, new workbook window open. Now do the same with your reporting file open and compare the appearance. It is not unlikely that you have gained a lot of custom styles with funny names like Normal 1, Normal 1 1, Normal 1 2 1, ...
Also, have a look at Name Manager (Formulas tab). Anything unexpected there? Finally (for this post anyway), on the home tab, click the binoculars and choose "Selection pane", check out how many objects are listed and whether that is expected. Make sure you select each worksheet to do this check.

The new spread sheet has tons more than the previous.  Could this slow down excel?  what causes them to be created?  can I delete them?  how do I find what they reference?

If you look (google) for "delete unused styles Excel" yu should be able to find a macro which does precisely that :-)
Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
70 Replies
Mouse right click pop-up menu stopped working in Excel 2013
Emil Garnev in Excel on
7 Replies
Date Formatting in a Pivot Table
Lorrie Griffin in Excel on
3 Replies
Security Warning: Automatic update of links has been disabled.
Mark Adams in Excel on
6 Replies
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777 in Excel on
49 Replies