Excel Bug?

[nagovind]

Dear All,

Please refer to the Excel sheet
https://dl.dropboxusercontent.com/u/101570276/Excel Bug.xls

Please refer to the Video
https://dl.dropboxusercontent.com/u/101570276/Excel bug.wmv

I tried to create a new sheet by copying the existing sheet using Ctrl+Shift+Mouse click

First copy is OK but copying the same sheet to another one created a massive error

Please provide a solution

Thanks
Govind

 

[bobhc]

Good day Govid

Right click on the sheet tab of the sheet you want to copy and choose move or copy and doing it that way will not bring any errors.

 

[vijay.vizzu]

Dear Nagovind

This problem appears due to hidden range names. So if you delete hidden range names from your workbook, then it will resolve your problem

http://support.microsoft.com/kb/119826

 

[SirJB7]

Hi, nagovind!
This is the late reported Excel bug and unfortunately it affects all Excel versions. For first time in history, Redmond guys are innocent.
http://chandoo.org/forum/threads/countifs-count-blanks-if-date-populated.15545/#post-93816
Regards!

 

[nagovind]

@ vijay.vizzu,

Thank you very much

VBA code in the below KB resolved my issue with a single click

http://support.microsoft.com/kb/119826

@ bobhc

Thank you very much
Your way of handling the issue also resolved the issue without taking any measures