In Excel 2010 on 2 different computers, the same file opens differently as follows:
Correct:
Incorrect:
The correct one is displayed first. This is a file exported from a SQL Server Report; when most of us export it displays correctly, but on one computer when they export it displays incorrectly and trims the top edge (compare the two 'navigation' column headings that should display BI Navigation
. When the other person uses save and send, or saves and attaches it to an email, the same file opens correctly on my computer. I've tried to recreate the problem by adjusting screen resolution to various settings, I've been through Excel's options and I can't see anything that might be doing this.
Note that the spreadsheet export has a number of tabs with the same layout, but where the column headings are different (ie shorter or longer text), the row height that contains the column headings does adjust to fit, but still trims the characters.
Note also that resizing the row height either using autofit by resizing manually does not fix it; the top edge is still clipped.
CSV
orXLS
file? Is the formatting coming from the SQL server? I would expect the server to simply export data, not formatting. Have you tried to import the data from the file into a clean sheet?