Hi all,



I'm first-time MSO Forums poster and xls newbie who would appreciate a little feedback to a small problem that I can't seem to resolve.

I've made myself a useful spreadsheet that is peppered with pertinent comments. It presents itself well.....that's the good news.

My problem is that whenever I insert a new row to this xls (say midway down the sheet), many of the comments that appear in the cells beneath my new row get disrupted. Either the box around the comment expands (no longer frames the text neatly) or worse......the box around the comment compresses (and the text is no longer legible).

I then have to go and resize the box around each affected comment individually.....there's got to be a better way to go about this!!

Could someone please explain how to insert rows to my spreadsheet without disrupting the existing comments in the cells of rows below??

TIA for any replies

ok

P.S. I'm using Microsoft Office Excel 2003

Hi okaynowwhat
Can you post a sample as I have just tried it and it works fine for me.
Tony

Appreciate the reply Tony.

I'll gladly post a sample of what I'm referring to....please advise how to attach an xls spreadsheet to these forums

thx

ok

Hi
Simply click on the blue "Quote" button in the bottom right hand corner of your entry and click on the paper clip. Click on browse to find the file to load and then click on upload.
Tony

Okay, try this....

Open the attached file (select Read Only if necessary).

See the comment in cell H17 ("Why do I sometime feel so confined")?

Now click on the blue cell (D12) and Insert a row (the blue cell moves to row 13).

Now go back to the comment (now located at H18).....can't read it right??

Even when you undo "Inset row", the comment remains corrupted.

Of course, it would be no problem to simply resize my rectangle to fit the text in this example but, keep in mind, the xls that i mentioned in my first post has many comments.....there's got to be a better way.

thx
ok

Attached Files

tester1.xls (39.0 KB, 10 views)

Hi

I have done what you have indicated in your spreadsheet and can recreate the problem. However I could not recreate it in a copy of the spreadsheet.
I tried it on a new spreadsheet and could not recreate the problem.
I copied your sample data to a new spreadsheet and could not recreate the problem.
I can only deduce there is a problem with your spreadsheet.
I have attached my sample so you can see.
Hope this helps.
Good luck.
Tony

Attached Files

Comments Spreadsheet Test.xlsx (23.4 KB, 13 views)

Hmmmmm....

Maybe you're right Tony, it could be the spreadsheet. I hope I find a resolution though without having to sacrifice my xls, and the many hours of hard work that I put into creating it.

Thanks for taking a stab at my problem

ok

You could try coping all your data to a new spreadsheet (NOT SaveAs).
And see if that cures the issue.
Tony

You're right, this does work.

The comments seem to reset to their initial "lay-out" in the new spreadsheet.

Again...thanks Tony, appreciate the help

ok