I have a UDF that references a network file. The UDF is set up so that it won't calc unless you press a toolbar button... Sometimes, I'll be sending these files to other people who don't have access to the network drive that the UDF reference... so I need to prevent the UDF's from calcing when the file opens. I just want them to see whatever value was previously in the cell.
I tried setting calculation to Manual... but as soon as I set it back to automatic, the values go back to 0.
I need to stop the UDFs from performing any operations until I press the button.