| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lost formats
Occasionally when pasting between two 2007 spreadsheets, I will lose all the
formating on the spreadsheet I am pasting to. Is there a way to recover the formats that are lost? (in this case, both files are open in the same Excel 2007 window) Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lost formats
If you want to preserve the formatting then right-click and choose Paste
Special then choose Values...(or Formulas if you also want to copy formulas) ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Deriv001" wrote: Occasionally when pasting between two 2007 spreadsheets, I will lose all the formating on the spreadsheet I am pasting to. Is there a way to recover the formats that are lost? (in this case, both files are open in the same Excel 2007 window) Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lost formats
It doesn't give you the option to save special. Just as as an object or
picture or bitmap. "Sheeloo" wrote: If you want to preserve the formatting then right-click and choose Paste Special then choose Values...(or Formulas if you also want to copy formulas) ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Deriv001" wrote: Occasionally when pasting between two 2007 spreadsheets, I will lose all the formating on the spreadsheet I am pasting to. Is there a way to recover the formats that are lost? (in this case, both files are open in the same Excel 2007 window) Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lost formats
That means that you have two separate instances of Excel... that is why you
get this problem only 'sometimes'... One way to fix the problem is - Close Excel first and On the Windows Taskbar 1) Start-Run- excel.exe /unregserver -OK. 2) Start-Run- excel.exe /regserver -OK. See the space between exe and /regserver You might have to designate a full path to excel.exe (most likely C:\Program Files\Microsoft Office\Office12) In that case Start-Run- "C:\Program Files\Microsoft Office\Office12\excel.exe" /regserver - OK Note that quotes are required because of spaces in the path ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Deriv001" wrote: It doesn't give you the option to save special. Just as as an object or picture or bitmap. "Sheeloo" wrote: If you want to preserve the formatting then right-click and choose Paste Special then choose Values...(or Formulas if you also want to copy formulas) ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Deriv001" wrote: Occasionally when pasting between two 2007 spreadsheets, I will lose all the formating on the spreadsheet I am pasting to. Is there a way to recover the formats that are lost? (in this case, both files are open in the same Excel 2007 window) Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
| Lost charts and conditional formats when connecting an LCD monitor | Excel Discussion (Misc queries) | |||
| File Error. Some number formats may have been lost. | Excel Discussion (Misc queries) | |||
| Chart Series Formats lost when list re -sorted | Excel Discussion (Misc queries) | |||
| How do I keep a running total of pounds lost and percentage lost | Excel Discussion (Misc queries) | |||
Linear Mode
