Office XP - Excel 2002; Column formatting & Formulas Do Not Copy

  • Thread starter Thread starter Harv
  • Start date Start date
H

Harv

In an existing workbook I have a blank preformated and preformulized
worksheet. When I copy this worksheet into a new workbook all of the column
formatting and formulas are deleted. Can this be fixed in this version of
Excel? Your help is very much appreciated!
 
Sounds like you are copying between two workbooks each of which is open in its
own instance of Excel.

Close down one instance of Excel and open both workbooks in one instance.

You will have better results with the copying.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
Analyze with excel (change access date format) 4
Excel 2007 Move or Copy worksheet 2
Copy cells in Excel 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
help with formula for last input in column 6
I cannot copy the columns of formulas in this Workbook::: AHHHHHHHHHHHHHHHH 6

Back
Top