Is there a way to save a file that has many links and macros as a file of another name that contains all of the information contained in the original file, and looks identical, but breaks all links, formulas, and macros?
I will admit I've never written VBA code for Excel, so my approach may not be what you need, but it works for my purposes. It would seem to me that you should be able to write a macro (or use the Recorder) to accomplish the same results.
I simply highlight the entire worksheet, Copy, Paste Special, Values. You can also Paste Special the Formats in another step.
Hope that gets you started in the right direction.