98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Excel Freeze Panes
excel training course - Excel Freeze Panes
Resolved · Low Priority · Version Standard
Mon 2 Jul 2007, 14:44Delegate Matt said...
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.
Tue 3 Jul 2007, 12:24Trainer Amanda said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create Charts with One keystrokeCreate a graph with one click |
