Share via

Excel cell color disappears

KT 11 Reputation points
2021-06-02T02:38:29.803+00:00

When I upload a local Excel file to SharePoint Online, the color in the cell disappears.

Is it a bug in Excel 365?

The file extension is ".xlsm".

If you have any information, I would appreciate it if you could let me know.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,230 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jerry Xu-MSFT 7,961 Reputation points
    2021-06-02T08:07:05.877+00:00

    Hi, @KT ,

    I tested with several .xlsm files in my end and do not witness similar issue. It may be an issue with this file only. You can have a test with other .xlsm file with the same process(use a copy of the file with issue). If it is a file level issue, just change the cell color again or simply recreate a new file.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Paul Casey 1 Reputation point
    2021-06-03T08:54:31.32+00:00

    I have exactly the same thing, only with a variety of .xlsx files.
    Open in excel from a local file and everything is fine.
    Upload to Sharepoint and select Open in App and everything is fine
    Open using the web version of Excel and the colours are gone.
    Re-open using Open in App and the colours are still missing.

    Super confused!

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.