Excel misbehaving - paste special and style problems?

[summer]

hi everyone - I have a general Excel 2007 problem.

I have a workbook which worked fine until now.

I use 'save as' at the end of each month to create a new workbook for the current month whilst retaining all the macros etc.

worked fine past few months.

however this month I have found 2 problems - not sure if they are connected.

problem 1. my workbook did its 'save as' thing ok but when I try to use cut and paste from a different workbook I have to use 'paste special' and select 'text'. It hasn't done this in the past. Copying within the same workbook is fine.



problem 2. If I try to do 'save as' a 2nd time (ie to get a dummy copy to work on whilst trying to solve problem 1. the new copy has to be 'recovered' by excel and the recovered version has lost all the pervious formatting. I get this from the online help they give you:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error053040_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Documents and Settings\Desktop\Perf June 09.xlsm'</summary>

- <removedRecords summary="Following is a list of removed records:">
<removedRecord>Removed Records: Style from /xl/styles.xml part (Styles)</removedRecord>

</removedRecords>


- <repairedRecords summary="Following is a list of repairs:">
<repairedRecord>Repaired Records: Format from /xl/styles.xml part (Styles)</repairedRecord>

</repairedRecords>


</recoveryLog>





does anyone have any ideas about what is going on? I hate it when things 'just change' lol

 

[Andrew Poulsom]

Problem 1 will happen if the workbooks are in different instances of Excel. In other words Paste Special is behaving as if you are pasting from another application, not from Excel.

 

[wsjackman]

check your default save-as save=as=type
I have had this change on me and give similar problems

 

[summer]

I had to remake the workbooks from scratch - I used cut and paste so not too bad, but still an effort. I think the workbooks had somehow become corrupt, which may be why the ctrl-V etc didn't work - ie the wb was corrupt so not appearing to be a wb to the 2nd wb....sort of like what Andrew said.

thanks everyone