When I split a worksheet it will not save

Question

I have a workbook that consists of all my finances. Each month has it's own worksheet.

When I split the work sheet, so that the balances towards the bottom of the spreadsheet are always visible at the bottom of the screen, it will not save!

I can save the workbook; but when I open it back up, some sheets are still split, and some aren't.

I've tried saving the workbook in all different file types. I can't seem to figure this out.

Please help.

Answer 1

Try following one by one and see after every step whether it resolves the issue-

1. Sometimes, add-ins can cause problems. To determine, if add-in is a problem start your application in safe mode and see if problem has gone away.

To start in Safe Mode -

Hold CTRL key and click on application icon and don't release the CTRL key till it asks you for Safe mode confirmation.

If yes, then start application normally and disable add-ins one by one and start application again every time you disable an add-in to determine the culprit add-in.

To disable add-in > File > Options > Add-ins > Down below you have Manage: Com Add-in : Press Go > Untick the Add-ins to disable and tick to enable them

2. Try repairing your office installation (Quick repair is good enough). Try repairing your Office installation. First try Quick Repair (takes 5 - 10 mins) , if that doesn't help then try Online Repair (Takes more than 30 mins but less than 1 hour in general)

https://support.office.com/en-us/article/Repair...

3. Login to Windows with a new user profile and see if problem is resolved.