Forum Discussion
How do get Excel spreadsheet to update?
Hi All,
New to the community.
I've added an Excel spreadsheet to my channel. This spreadsheet provides up-to-date information to the users in the channel.
Is it possible to set it up in a way that whenever I update the spreadsheet outside of Teams, it automatically updates it within Teams?
I've been playing around with it for a little bit by make changes to the actual spreadsheet, saving it, then going into Teams, refreshing, but the spreadsheet within Teams remains the same.
Any help would be appreciated.
Thanks,
Jason
2 Replies
Hi Jason - welcome to the community! We're glad you're here.
The file you have added to the channel in Teams is 'the' file. You can make updates to it in Excel when you aren't logged on to Teams and you can locate it in SharePoint. When you are in Teams, you can make edits directly in Teams, via the web version, or you can choose to open in the native app and make edits or updates there.
You might be working on two different versions. For instance, if you make edits to a doc on your desktop, that's not going to edit the version you uploaded to Teams. If you have two versions, you'll want to delete any other version and just work off of that master spreadsheet you want to have updated for our team members.
Again, you don't have to be logged into Teams to work on it - it's a file stored in SharePoint that is accessed by Teams.
Let me know if I might be misunderstanding your question but hopefully that will help you.
Laurie Pottmeyer
Hi Laurie - to your point, i would like for my Teams "channel" to have the Sharepoint version of my file. Is there a way to add Sharepoint files into Teams so that the Sharepoint updates are visible to everyone? (My Teams excel file will be view only).
