I have a worksheet where there are metrics that are updated daily.
I would like to send this spreadsheet to some client and when I update some spreadsheet information on my computer, this information will automatically be updated in the sent worksheet (which is with the client).
Is it possible to do this?
I believe you will not be able to do this without you sending back to your client after each change, because you send a copy of the Excel file in question. then it would be impossible for it to be updated automatically, this would only be possible if your client in question was on the same network as you and you placed that file on the network. or you can use the online Excel editor that already comes in your email microsoft and create a file shared with your client, so yes it would work.
