Format in Dynamic Worksheets changes when collegues refresh the data

(0) Share

Report

Posted on by Tobias F

Hi everyone,

I have an issue with time formats in Dynamic spreadsheets. When I share them with other people in the company, the format somehow changes for some rows after they refresh the file. Excel then displays the content incorrectly. Even when the users manually change the column formatting accordingly, it makes no difference. However, if I refresh again it displays correctly for me. Could this be due to the fact that we are an international organisation and the different countries have different formats per default in Excel?

As can be seen in the below example, some rows are displayed correctly (the dates), while some are confusingly just a bunch of numbers.

Excel Version:

It would be great if someone could advise.

Thanks a lot.

All responses (2)

Answers (0)

Tobias F on at

Like (0)

Report

RE: Format in Dynamic Worksheets changes when collegues refresh the data

Hi Leah,

thank you for the suggestion. I'll try that too.

Regards
Community Member Microsoft Employee on at

Like (0)

Report

RE: Format in Dynamic Worksheets changes when collegues refresh the data

Hi Tobias,

Maybe you can post thread into excel forum for further help:

Microsoft Excel Community