% Complete automatically filled to 100%

pauline.t

Hi all,

In my Programme Management sheet, I am linking cells from project sheets, including the "% Complete" cells to have an overview of all projects. When I am linking the cells, the % Complete cells automatically show 100%, even though the percentage in the source sheet is different. Any idea why?

Paul Newcome

Can you provide a screenshot for context?

pauline.t

Hi Paul,

Below is a screenshot of my programme sheet. You can see that cells are linked from another sheet (a project sheet) and that the percentage is 100% everywhere.

And here below, the screenshot of the cells linked to the Programme sheet. Even though the percentage changes in the project sheet, it is not reflected in the programme sheet. I find that it works if I remove the links and link the cells again. However this is a large programme with lots of project and would prefer not to do it again.

I don't know why all cells got 100% percentage. There is no automation running.

Paul Newcome

You may need to reach out to Support. If deleting the link and then re-linking the cell fixes it, that points me in the direction of the issue being on the "back-end" that we don't have access to.