excel training course - excel freeze panes

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Excel Freeze Panes

excel training course - Excel Freeze Panes

resolvedResolved · Low Priority · Version Standard

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


Server loaded in 0.09 secs.