Saving issue on excel

[By727]

I am having an issue with excel corrupting the text formatting on my file. I am using Office 365 on an XPS 13 (2015), and the following picture is what I see. When I open the document fresh from my coworker, excel wants me to save even though I have made no changes to the file. This leads me to believe some formatting change must be getting saved from my end.

When I continue to make the save, the format remains unchanged on my end; however, the document appears as seen below when it is sent back to my coworker:

How could I fix this issue? Help would be much appreciated.

 

[Joe4]

Welcome to the Board!

That behavior sounds like something that would happen if you opened a file that wasn't in an Excel format, but maybe a text format (like CSV) and is going through an automatic conversion when being opened (which is why it is prompting for the Save).

Or perhaps you co-worker is using an old version of Excel.

Are you sure it is a valid Excel file as it comes over?
What is the full name and extension of the file?
How is your co-worker delivering the file to you?
How exactly are you opening it?
What version of Excel is your co-worker using?

 

[By727]

For some reason I am having difficulty uploading pictures for illustration. Below is the problem I am having with excel.

Row numbering and text in column D:

[/IMG]

 

[By727]

Thank you for your prompt reply!

Are you sure it is a valid Excel file as it comes over?
Yes, it is a valid .xlsx file
What is the full name and extension of the file?
Payroll. xlsx

How is your co-worker delivering the file to you?
The file is being delivered through dropbox

How exactly are you opening it?
I am saving the copy to my desktop, then proceeding to open it. The issue persists even if I open the file directly through dropbox.

What version of Excel is your co-worker using?
Microsoft office 2013/2016

 

[Joe4]

What kind of changes are you seeing?
Is the co-worker in a different part of the world as you (I wonder if they may have different regional settings)?
Is there any VBA in the file, especially a Workbook_Open event procedure?

Note there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.
I am not sure how much images will help in this instance though.

 

[By727]

If you refer to the image in post #2, the corrupted formatting is illustrated in the row numbering (weird overlap) and the alignment of text in column D.

 

[Joe4]

If you refer to the image in post #2, the corrupted formatting is illustrated in the row numbering (weird overlap) and the alignment of text in column D.

I am sorry, but that image is not viewable to me. My place of employment blocks images from external sites (part of corporate security policy - cannot see or download anything from file sharing sites). I can only see them on my home computer.

 

[By727]

Bump

 

[RoryA]

I don't see anything particularly strange there - it just looks like a combination of frozen panes and hidden rows.