@NetworkNerd said:
Man, I can completely identify with the problem you're having. We have an Estimating tool that is much the same. If you change the code in the master template, it's near impossible to propagate that change to every other spreadsheet that already exists. There may have been columns added, etc., and that can make things even more complicated.
I agree when I finally demote that old server and use a CNAME, the problem will be resolved. The new file server has an alias so it will make the next migration much easier.
It still doesn't change the fact that our backbone to our panels, purlins and roofs are all determined by an extremely messy and complicated VBA project. For someone who isn't a developer and just doesn't have the time to study (believe me, I've tried), it will be a herculean effort to convert this to another format one day. I've been able to enhance it here and there but not by much.

