Sharing an updating Excel workbook

Copper Contributor

If I have a workbook with many tabs, some pulling information from other tabs and I want to separate each tab as an individual sheet to send to a client, will it update when I add info to the main document in my workbook? I think the answer is no, not without being connected to the Cloud etc. So the only other options would be Google Sheets or One Drive, correct?

2 Replies
You can use OneDrive for that too, using "regular" Excel files. After saving a file to OneDrive you can use the Share button on the top-right of Excel to create a sharing link for your client.

@Jan Karel Pieterse Thank you, she did not want to use One Drive (unknown reason) but now knows she has to use some form of sharing to achieve her goal. Thanks again.