I have a workbook which is saved over our public network. It is protected and shared so that mulitple users can make changes to it at the same time.
The problem is, the frozen panes on the sheet work for me all day long but it does not work for anyone else using the workbook.
I've checked the options before protecting the page and there is nothing in there about frozen panes, am I doing something wrong? Is there a setting in Excel that they need to tweak on their end?
I have searched in the help files for hours but have been unsuccessful.
Please help!
The problem is, the frozen panes on the sheet work for me all day long but it does not work for anyone else using the workbook.
I've checked the options before protecting the page and there is nothing in there about frozen panes, am I doing something wrong? Is there a setting in Excel that they need to tweak on their end?
I have searched in the help files for hours but have been unsuccessful.
Please help!