I have a couple of very large workbooks (12k) with specific page breaks and
print ranges. Upon opening each time there are changes in print formats,
margins, and even formulas lost and replaced with Values. Each time I save I
also lose my hyperlinks to let users go directly to the cell they use to
start the day's business. This is in an attempt to make a workbook adding
monthly values in each sheet x 12 months, and a summary sheet. It is not
overly complex, but the re-formatting is making me look for other solutions.
I would prefer not to have to have a workbook for each month, and then use 12
separate workbooks, one for each month, times four departments, you get the
idea.
Any assistance would be appreciated! TC