hey Lorna,
If as part of an update process Excel delete rows (or
columns or the entire sheet and then replaces it) the freeze
panes will move around. is there any processes that
automagically happen which would cause this, or is the
workbook just stable with garden variety links to other
workbooks?
regards
Darryl.
-----Original Message-----
From: MS Excel General Q & A List
[mailto:EXCEL-G PEACH.EASE.LSOFT.COM]On Behalf Of Lorna
Olsen
Sent: Tuesday, 28 November 2006 9:20 AM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Randomly "thawing" Freeze Panes
Hi All!
I have a user that has a workbook containing many worksheets
that she
constantly updates. This workbook contains links to other
worksheets,
as well as external links to other workbooks as well.
In all of the worksheets except the first one, she has
chosen to
Freeze Panes between Rows 7 and 8. Periodically, when she
opens the
workbook, makes some changes to the data, closes and saves
the
workbook, it appears that Excel is automatically
"Unfreezing" the
panes. The next time she opens the workbook, some of the
worksheets
are unfrozen. We haven't been able to come up with any
pattern to
this, other than that she's updating and saving the
workbook. She's
using Excel 2003, and Windows XP.
Can anyone give me a clue here? I can't seem to duplicate
this
behavior - she sent me the workbook file, but not the linked
workbook files.
Thanks in advance!
Lorna Olsen
Technology Trainer
North Dakota State University
Fargo, ND
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
This email and any attachments may contain privileged and
confidential information and are intended for the named
addressee only. If you have received this e-mail in error,
please notify the sender and delete this e-mail immediately.
Any confidentiality, privilege or copyright is not waived or
lost because this e-mail has been sent to you in error. It
is your responsibility to check this e-mail and any
attachments for viruses. No warranty is made that this
material is free from computer virus or any other defect or
error. Any loss/damage incurred by using this material is
not the sender's responsibility. The sender's entire
liability will be limited to resupplying the material.
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|