Hello fellow board members, I'm using Excel 2010 Win7 and getting very odd program behavior, maybe you can help me?
Do the following:
-Open a new blank .xlsm workbook
-Select a cell in sheet2 (say B2) add a comment with an image in it
-Select another cell in sheet2 (say B4) add a comment with an image in it
-Select another cell in sheet2 (say B6) add a comment with an image in it
-Highlight line 2, copy, and then paste it in sheet1 as new line 2
-Highlight line 4, copy, and then paste it in sheet1 as new line 4
-Highlight line 6, copy, and then paste it in sheet1 as new line 6
-sheet1 and sheet2 are now identical
-Close and save the workbook
-Reopen the workbook
-Highlight line 4 in sheet1 and delete it
-Save the workbook
-Reopen the workbook
The following error message appears:
"Excel found unreadable content in <file name="">...Do you want to recover the contents of this workbook? If you trust the source of this workbook, click yes"
After clicking yes I get a message saying the program managed to repair the file by removing the unreadable content and this:
"Removed Part: /xl/drawings/vmlDrawing1.vml part. (Drawing shape)"
....other than the annoying message that appears, all the images inside the comments in sheet1 are also gone (!)
Does anyone know what is going on?
thanks for any help
</file>
Do the following:
-Open a new blank .xlsm workbook
-Select a cell in sheet2 (say B2) add a comment with an image in it
-Select another cell in sheet2 (say B4) add a comment with an image in it
-Select another cell in sheet2 (say B6) add a comment with an image in it
-Highlight line 2, copy, and then paste it in sheet1 as new line 2
-Highlight line 4, copy, and then paste it in sheet1 as new line 4
-Highlight line 6, copy, and then paste it in sheet1 as new line 6
-sheet1 and sheet2 are now identical
-Close and save the workbook
-Reopen the workbook
-Highlight line 4 in sheet1 and delete it
-Save the workbook
-Reopen the workbook
The following error message appears:
"Excel found unreadable content in <file name="">...Do you want to recover the contents of this workbook? If you trust the source of this workbook, click yes"
After clicking yes I get a message saying the program managed to repair the file by removing the unreadable content and this:
"Removed Part: /xl/drawings/vmlDrawing1.vml part. (Drawing shape)"
....other than the annoying message that appears, all the images inside the comments in sheet1 are also gone (!)
Does anyone know what is going on?
thanks for any help
</file>