| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Office XP - Excel 2002; Column formatting & Formulas Do Not Copy
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! -- Harv H. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Office XP - Excel 2002; Column formatting & Formulas Do Not Copy
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 On Thu, 6 Mar 2008 14:16:04 -0800, Harv wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to open Office 2007 files using Office 2002 XP | Excel Discussion (Misc queries) | |||
| Excel 2002: Any formulas to look up unsorted column ? | Excel Discussion (Misc queries) | |||
| Office 2002 excel search | Excel Discussion (Misc queries) | |||
| Excel 2002; copy formulas to one workbook to another diff data | Excel Worksheet Functions | |||
| Despite formatting a column in Excel 2002 worksheet as Short Date. | Excel Discussion (Misc queries) | |||
Linear Mode
