Excel error when adding and renaming a tab

Experts,
I have received the following error from an Excel workbook that I have been using:

<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error056520_01.xml</logFileName><summary>Errors were detected in file 'C:\Excel\Function and Formulas for Excel.xlsm'</summary>-<removedFeatures summary="Following is a list of removed features:"><removedFeature>Removed Feature: Object from /xl/workbook.xml part (Workbook)</removedFeature><removedFeature>Removed Feature: OLE Control Extension from /xl/workbook.xml part (Workbook)</removedFeature></removedFeatures></recoveryLog>

I can tell you that when I add a new tab and rename it Excel stops and tries to recover the file, which is attached. I am lost on why this problem exists. Every machine with Excel 2007 or 2010 I get the same problem, so it appears the problem follows the file.
Function-and-Formulas-for-Excel.xlsm
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steven HarrisPresidentCommented:
I can tell you that when I add a new tab and rename it Excel stops and tries to recover the file, which is attached

I am able to add and rename a sheet with no errors.

Verified on 2010 and 2013 systems.
Function-and-Formulas-for-Excel.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Frank FreeseAuthor Commented:
This problem frustrates one because I'm left with reinstalling Excel and seeing where that takes me.  Can you possibly think of something in the modules or the way the workbook is set up that could be the problem.
Excel stops and recovers the file with the workstation at work and two different workstations at home. But the problem only appears when I name or rename a worksheet tab -
Appreciate it
0
EirmanChief Operations ManagerCommented:
This looks like a really useful work book, so I'm going to keep a copy for reference, if that's okay with you.

Anyhow I tried to rename a tab in excel 2010 (over a network) and excel crashed. So thinking it was a network/resorces issue I tried it locally and it crashed again. I haven't a clue why but at least you know it's the file and not your install.

Ask ThinkSpaceSolutions what his PC specs are .... it might cast some light on why it does not crash for him. 32v64 bit might be important.

Sometimes the only way to get to the bottom of this type of problem is to import sections a bit at a time into a clean worksheet, until it everything works okay .... or you can pin down the faulty section.

or ....
Delete half the sheets .... what happens ..... still faulty? delete half the remaining etc. This should narrow it down ... do you get my general drift.

I'm using windows 7 32 bit and office 2010 32 bit .... this is my error code ...
Problem Event Name:	APPCRASH
  Application Name:	EXCEL.EXE
  Application Version:	14.0.6024.1000
  Application Timestamp:	4d83e607
  Fault Module Name:	EXCEL.EXE
  Fault Module Version:	14.0.6024.1000
  Fault Module Timestamp:	4d83e607
  Exception Code:	c0000005
  Exception Offset:	007403da
  OS Version:	6.1.7601.2.1.0.256.4
  Locale ID:	6153

Additional information about the problem:
  LCID:	1033
  skulcid:	1033

Open in new window

This is my first excel 2010 crash, so there definitely something up with your file.

EDIT:
I opened your file in excel 2007 running on XP ... no problems .. I can rename/insert tabs ...strange!
0
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

Frank FreeseAuthor Commented:
The workbook is for my youngest son and I'm not even have way through. Several experts have gone the extra mile helping me build this so I cannot take the credit. I'm flattered that you've asked to keep a copy - no problem.
The problem did not begin until about a week ago, for no known reason. It is refreshing to know I have not lost my mind in that someone else is also experiencing problems with this workbook.
I'm running Win 7/64 on my two personal workstations with with Office 2010. At the Office they use Win 7/32 and Office 2007. But everything was working fine until just recently. It;s strange that once Excel crashes and recovers the workbook works fine until I try to add and rename another worksheet.
I'm going to keep this post open for a few more days
Thanks
0
Frank FreeseAuthor Commented:
ThinkSpaceSolutions,
Can you share what version of Office you're using as well as OS?
0
[ fanpages ]IT Services ConsultantCommented:
Hi,

Like ThinkSpaceSolutions, I opened the workbook in MS-Excel 2013.  I am using MS-Windows 8 presently, but I could try with earlier versions of MS-Excel &/or MS-Windows, if required, later today.

It initially reported "This action will reset your project, proceed anyway?", but after confirming [Yes], I could add a worksheet & rename it without any issues.

I have saved the workbook locally & attached it here in case simply re-saving has "resolved" the issue you saw.

Please try this copy & see if you still have problems.

Thanks.

BFN,

fp.
RE-SAVED-Function-and-Formulas-f.xlsm
0
EirmanChief Operations ManagerCommented:
Sorry Frank .... my last EDIT was at 4am and it was wrong .... I had not used Excel 2007 this year and I did not have macros enabled. So your file and the RE-SAVED version does crash in excel 2007 running on XP when renaming tabs.

I tried "open and repair"  ... no joy.

Just a possibility .... if the file is saved on a disk that has system restore enabled, there might be previous versions available by right clicking on it in file explorer and going to the "Previous Versions" tab
0
Steven HarrisPresidentCommented:
Verified on 2010 and 2013 systems.

PC #1 Specs:
Win8 (x64)
i7-4700MQ CPU @ 2.40GHz
32 GB RAM
Office 2013 (x86)

PC #2 Specs
Windows 7 Home Premium (x64)
i5-2410CM CPU @ 2.30GHz
6 GB RAM
Office 2010 (x64)

Virtual Machine (Running on the Win8 machine)
Windows 7 Home Premium (x64) (Virtual)
8 GB RAM
Office 2010 (x86)



Now, I had originally assumed that the Office 2010 (x64) install would be the go-to for this problem (seeing as it has no hard limits on File Size).  However, I tried all three system and received no errors.

If you take the workbook I attached, can you rename the tab I created?
0
Frank FreeseAuthor Commented:
Thanks to all
ThinkSpace, when I went back and used the workbook you first submitted my problems went away - I overlooked that post for some stupid reason
Again, to all thanks and if the problem reappears I'll be back
0
[ fanpages ]IT Services ConsultantCommented:
You're very welcome.

Fingers-corsesd here for you ;)
0
Frank FreeseAuthor Commented:
Thanks fanpage
Problem reappeared - will consider "code" somewhere before trying another post or copy worksheets to a new workbook along with all the code
0
EirmanChief Operations ManagerCommented:
copy worksheets to a new workbook along with all the code
I thought it might come to that. I've had to do that many time with large MS databases, but Ive never had an excel file large enough to bocome corrupted.

As a future strategy, use a backup program such as this for critical developement data http://www.kls-soft.com/klsbackup/
and have it create multiple backups to zip files. You select the number of zips you want to keep before the oldest is deleted. If you have daily backups and decide to keep 15 backups you  can always go back to any day over the previous two weeks and recover the data from any day.

You can do the same with a weekly run and go back months etc
0
Frank FreeseAuthor Commented:
I wish I'd done this in Access now but I'm over half-way through and this is for my son anyway.
I actually backup daily many times - to a flash drive, daily USB drive and as well as Carbonite.
Think I'm going to create the remaining worksheets in a new workbook and then move them to my master workbook. I'll let you know how that worked.
Thanks
0
[ fanpages ]IT Services ConsultantCommented:
Hi,

Sorry, I missed your recent comment asking me to return.

May I suggest trying to use one or both of these tools on your workbook to try to remove any extraneous, for want of a better word, garbage, that has collated in the file whilst you have been working on it?

"Microsoft Excel Excess Formatting Cleaner Add-in"
[ http://www.microsoft.com/en-gb/download/details.aspx?id=21649 ]

Rob Bovey's "Code Cleaner" Add-in
[ http://www.appspro.com/Utilities/CodeCleaner.htm ]


Always make a backup of the workbook before using any of these tools, & do not use more than one in succession without making a further copy as an interim step.  This will reduce the re-work necessary if the second tool proves unsuccessful & the content of the workbook has deteriorated rather than improved.

Good luck!

BFN,

fp.
0
Frank FreeseAuthor Commented:
fp,
I do not know how to thank you. It appears Code Cleaner did its' magic -
Since I've assign points already the least I can do is give you a copy of the incomplete workbook now and follow-up with a final later.
Frank
Function-and-Formulas-for-Excel.xlsm
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.