Matt has attended:
No courses
Excel Freeze Panes
We are currently having problems freezing panes within a shared Excel spreadsheet.
We have opened the spreadsheet, frozen the appropriate panes and then saved the document. These frozen panes then appear/are formatted for some users when they open the document from the shared location, but not for others - Is this because of their profile settings? If so, how would these be changed?
If anyone could help me with this problem, I'd be very grateful.
RE: Excel Freeze Panes
Hi Matt
Thanks for your question - an interesting one!
I haven't come across this before, but I wonder whether you are using Freeze Panes in combination with an AutoFilter, and the Freeze Panes to to keep the headings and filter arrows at the top of the screen? I've had a look in Google Groups and it seems to be something that causes people problems with a shared workbook:
http://groups.google.co.uk/group/microsoft.public.excel.misc/browse_thread/thread/9e29bac09623e6bd/092b4ce025eb3225?lnk=st& ;q=problem+with+freeze+panes+in+shared+Excel+file&rnum=1&hl=en#092b4ce025eb3225
If not, as you suggest, it could be something associated with individual users settings. I've found something about someone who had a similar problem with not having universal print settings amongst users of a shared file, and thought this might shed some light on the situation:
http://groups.google.co.uk/group/microsoft.public.excel.misc/browse_thread/thread/91de4bef0882398/2e5fef8dd91cf1e7?lnk=st& ;q=problem+with+freeze+panes+in+shared+Excel+file&rnum=13&hl=en#2e5fef8dd91cf1e7
I don't know if either of these will help, but it might be a start.
Amanda
