asked on

Excel 2010 - Cells become large when saving

I have a customer who is telling me that when she saves an Excel spreadsheet that the cells become really large. Saving triggers it. To revert to "normal" she has to close and reopen the spreadsheet.

Excel 2010 running under Windows 10. Ideas?

Carol Chisholm

Too many styles due to the sheet being opened in many different systems.
To clean them
https://support.microsoft.com/en-us/kb/291321

http://www.mrexcel.com/forum/excel-questions/508248-excel-2007-remove-all-custom-styles.html

Spencer Scherer

I would try one of the following. It may be formatting (bottom aligned) or something else. Let me know if any of these help:

1. Boot Excel 2010
2. Open [Excel Options] dialog. ([File]-[Options])
3. Select [Advanced] tab, turn on [Cut, copy and sort inserted objects with their parent cells] option. (In [Cut, copy and paste] section)

*This will not resize rows that are currently set to 409.5 but I would like to know if this keeps rows from doing this in the future.

Additionally, have her highlight all of the fields and change alignment to top rather than bottom. This should resolve it for that instance.

LockDown32

ASKER

This is a very small network, 5 users total. The odds of a second person opening the same spreadsheet are probably zero.

It is not a select few spreadsheets. It is every spreadsheet she opens (and then saves).

ASKER CERTIFIED SOLUTION

LockDown32

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LockDown32

ASKER

No solutions given