Inserted Row Shows Up as Hidden Row in Shared Workbook Excel 2003

[rlferber]

The other day I inserted a row in a shared workbook and then saved it. On my screen, the inserted row was visible and was the correct row height of 12.75. My goal was to insert the row so another user sitting next to me could enter information in the new row.

After I saved the workbook, and after the user sitting next to me saved her workbook, the row I inserted should have appeared exactly the same on her screen, but it did not. Instead, the inserted row showed up as a hidden row on her screen. It was there, but the row height was collapsed to the point of invisibility.

I repeated my attempt to insert a row which the other user could edit several times, but each time I got the same result. I could not make the row show up on her screen with a row height of 12.75.

I am stumped. Has anyone else encountered this problem with a shared workbook in Microsoft Excel 2003?

[dilipandey]

Hi rlferber,

Hope you have resolved this query by now.. As per my experience, I have observed that if you do any structural changes in the shared workbook, then those will be available when the other user closes and re-opens the workbook.

Also, if a user has set the width of all the rows as 10, then how can your row with a width of 12.75 can override his own settings till the time workbook do not refreshes... thanks.

Regards,
DILIPandey
<click on below * if this helps>