"Rows to Repeat at Top" Does Not Save

[lloyddd]

I have a workbook that that needs to have the top 2 rows of various worksheets repeat when printed; however, this must be selected everytime it is opened. I have never had a workbook where this option was not saved.

Workbook details
1) Workbook is shared
2) Contains 36 Worksheets (every other worksheet needs to have repeating rosw)
3) File size is 1.6 MB
4) There are no macros in the workbook

The workbook was recently cleaned of any links and was retyped from a blank worksheet. What causes this option to not save?

[Leith Ross]

Hello lloyddd,

It sounds like you are having to do this each time for the specific sheets. After you have setup the Page Formatting for the specific sheets and save the workbook, the workbook should "remember" your settings. Sounds like something in the workbook is causing the problem. I would suggest you reduce the file size, zip it, and send it as an attachment with your next post for further review.

Sincerely,
Leith Ross