The problem is the setting seems to be permanently set to formulas so I would have to implement this macro in every new file I create moving forward which is a hassle. I wish there was an option to simply set to values permanently.

I think the easier option will be to try and remember to set to values when I first open an excel file but I use excel so much this will be impossible to remember every time