Stop Document auto updating from a remote source

Hi guys...

I am appealing to everyones superior knowledge with excel to try and resolve a problem I'm having at work. I have inherited quite a complex speadsheet with numerous handwritten vb macros (something I'm not familiar with) and when I update and send out the document to the relevant people the document will automatically update itself (on their machines - they apparently get the option to click update - but I dont want them to have it). However this is an issue as I dont want them having an up to date view, I just want them to have that snapshot. I thought about just cutting and pasting the values into a separate sheet, but they need the necessary macros etc that do all the workings out if they want to play with the numbers... Also, the document is updating itself from a source (sharepoint) online that each person has access to.

So, in short - what can I do to stop these excel documents having the option to update themselves?

Thank you soooooo much in advance for any help you might be able to offer