Solved

Can't get one of my Excel 2003 Workbooks to move or copy worksheet

Posted on 2011-03-23
5
269 Views
Last Modified: 2012-05-11
Hi

I have one particular workbook I am working with that all of a sudden will not allow me to move or copy worksheets when right-clicking the worksheet and selecting the worksheet, either to a different workbook or to another spot on the same workbook.

1: I can drag a worksheet with the left mouse to a different spot
2: I can change tab color delete and insert and rename worsheets
3: Other workbooks work fine
4: This workbook is neither shared or protected as far as I can tell
5: Renaming the workbook has no impact
6: Turning off the computer and restarting does not have any impact
7: I can open another workbook and copy worksheets to the problem one

The only thing I can do is copy all the info over to another workbook.  i REALLY don't want to do that!
0
Comment
Question by:alanvcole
  • 2
  • 2
5 Comments
 
LVL 22

Expert Comment

by:rspahitz
ID: 35200073
If you make a copy of the original, does the copy also have the same problem?
We can probably create a macro to copy all of the formulas to a new workbook/sheet if that would help.
0
 

Author Comment

by:alanvcole
ID: 35200299
Yes, a copy still has the same issue

0
 
LVL 6

Accepted Solution

by:
FernandoFernandes earned 250 total points
ID: 35200655
This is not the first time something like this happens, i could never figure out what causes it...

You'll have to copy all the content over to another workbook... this was the only solution...
I have a script which may help you...

you can either post the file here (then I can replicate it for you), or look at this link, the addin with the script (ReplicateWorkbook.xla) can be downloaded from there.

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26824746.html
0
 

Author Comment

by:alanvcole
ID: 35200809
OK!  While I didn't get a chance to do your solution, reading the thread sent me to another solution from tevlyn.

Save as a web page with diff name
Close Excel
Open Excel
Save as Excel  workbook

and it worked!  

TY Fernando, tevlyn and EE
0
 
LVL 6

Expert Comment

by:FernandoFernandes
ID: 35200945
Nice! :-)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Formula 6 45
Excel Score Formula 5 46
Incorporate VBA Code to work with Original Workbook 23 23
NEED TO UPDATE DATA IN EXCEL 18 21
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now