I have a workbook with 78 identical, protected worksheets and a summary page with links to specific cells on each page. When I need to make a change, it is much simpler to delete all sheets but one, make the change once, make 77 copies, rename them and reconstruct the summary page. It never fails that Excel will close when I try to save the workbook. I combat this by copying in smaller groups and saving after every change. This helps but I can still plan on it shutting down 3 or 4 times before I finish.
Anyone know why this happens or what I can do to prevent it?
Anyone know why this happens or what I can do to prevent it?