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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies