cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

On refresh of Excel: the line item at the end of the list is not alined

I don't know where to post this question so I put it off topic.

Every day I refresh an Excel file that is linked to my Sharepoint list, in order to retrieve in Excel the latest updates that have been made in the Sharepoint list.

In my Excel table I added some extra columns to the right of the data that gets uploaded from Sharepoint. These columns on the right are filled in manually by me. For example I would add comments that relate to a specific line item.

For my comments on the right to stay alined with its respective line item, I make sure that no line item gets deleted from my Sharepoint list. Otherwise, they move lines in my Excel list whereas my comments stay on the same line.

This method works, exept for the last line of the Excel table. If I enter a comment on that line (at the right of the data updated from SP list) and I refresh the Excel with the latest SP data, these comments added in the last line will have moved to a line further down (one of the lines added with the refresh).

Doe anyone have experience with this method and this issue? Or can you think of a better method? I know I could add these columns on the right in the SP list, but in my configuration these comments on the right are just for managing the tasks within my team, and entering them in Excel is much faster than entering them in the Sharepoint form for every single item.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Kudoed Authors
Users online (6,858)