| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
I have been using a spreadsheet with formulas for years to track informaiton.
When I attempt to copy a single sheet of the workbook in to a new workbook the formulas convert to values. I have copy and pasted, used the paint brush.... The only solution I have found is to save as and delete the sheet I do not want in the new work book. Is there an explanation for what is happening? -- Susanne |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003
Hi Smuessing,
uselly this happen if cell is already has format value. so before pasting the formula use pant brush from a cell where formula is working to where formula is not working. do not use format option insted of paint brush. "SMuessig" wrote: I have been using a spreadsheet with formulas for years to track informaiton. When I attempt to copy a single sheet of the workbook in to a new workbook the formulas convert to values. I have copy and pasted, used the paint brush.... The only solution I have found is to save as and delete the sheet I do not want in the new work book. Is there an explanation for what is happening? -- Susanne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
| opening excel files from access 2003, win xp, office 2003 | Excel Discussion (Misc queries) | |||
| import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
| Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
| Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) | |||
Hybrid Mode
