Shared File & Freeze panes issue

We are using a Shared file, but the Freeze panes at 
times "resets" so that it appears the screen is frozed 
unitl you reset freeze panes.

This is not due to user changesm but occurs in the 
original file that was emailed.

Is ther any way to prevent this?
0
anonymous (74722)
10/2/2004 2:42:16 AM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
798 Views

Similar Articles

[PageSpeed] 43

There's a guy at work who sometimes applies Window|Freeze panes to a filtered
list.

While the list is filtered the way he has it, you can see the titles and the
data nicely.  

But when you do Data|filter|show all (or reset the filter), the cell used to set
the freeze panes is now off the viewable screen and it looks like the display
won't move.

An example.

He applies data|filter|autofilter to his data.  Filters on a value in column A. 
You can see sell A1 (headers) and then A65.  He selects A65 (the first visible
cell under the header) and applies window freeze panes.

But when someone shows all the data, Rows 1 to 64 are frozen.  And the screen
looks frozen when scrolling around.

Removing the freeze panes and reapplying when the filter isn't engaged returns
things to normal.

Maybe it's something as simple as that -- and nothing to do with the
"sharedness" of the workbook at all.

SCA wrote:
> 
> We are using a Shared file, but the Freeze panes at
> times "resets" so that it appears the screen is frozed
> unitl you reset freeze panes.
> 
> This is not due to user changesm but occurs in the
> original file that was emailed.
> 
> Is ther any way to prevent this?

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
10/2/2004 2:25:52 PM
Like SCA, I believe this is a shared file (with filters) issue, since it 
doesn't seem to happen on non-shared files. Here's the problem:

I have a habit of freezing the top two rows in my workbooks (with multiple 
worksheets) so that column headings in row 1 and filters in row 2 are always 
visible when I scroll down. In shared files only, the freeze frame will have 
mysteriously jumped down to another row, for example row 100, when I first 
open the file. In other words, when I first open the worksheet, I might see 
rows 1 to 30 on my screen, but I can't scroll down because the freeze frame 
is down at row 100. This can happen at odd times on all worksheets in a 
workbook, or just some of them. So unfortunately, I often end up having to 
reset the freeze pane under row 2 again for all or some of the worksheets. 
Since there are only two of us in the office sharing these workbooks, I'm 
confident that neither of us are inadvertantly changing the placement of the 
frozen panes. Perhaps the fact that we are both filtering columns and saving 
the shared workbooks is causing Excel to reset the freeze pane inadvertantly.

If someone could figure out this problem it would be very helpful to me. 
Shared workbooks are a powerful tool but I have to limit there use to just a 
few power users, sothis problem really limits my ability to use shared 
workbooks more broadly in my office. 

"Dave Peterson" wrote:

> There's a guy at work who sometimes applies Window|Freeze panes to a filtered
> list.
> 
> While the list is filtered the way he has it, you can see the titles and the
> data nicely.  
> 
> But when you do Data|filter|show all (or reset the filter), the cell used to set
> the freeze panes is now off the viewable screen and it looks like the display
> won't move.
> 
> An example.
> 
> He applies data|filter|autofilter to his data.  Filters on a value in column A. 
> You can see sell A1 (headers) and then A65.  He selects A65 (the first visible
> cell under the header) and applies window freeze panes.
> 
> But when someone shows all the data, Rows 1 to 64 are frozen.  And the screen
> looks frozen when scrolling around.
> 
> Removing the freeze panes and reapplying when the filter isn't engaged returns
> things to normal.
> 
> Maybe it's something as simple as that -- and nothing to do with the
> "sharedness" of the workbook at all.
> 
> SCA wrote:
> > 
> > We are using a Shared file, but the Freeze panes at
> > times "resets" so that it appears the screen is frozed
> > unitl you reset freeze panes.
> > 
> > This is not due to user changesm but occurs in the
> > original file that was emailed.
> > 
> > Is ther any way to prevent this?
> 
> -- 
> 
> Dave Peterson
> ec35720@msn.com
> 
0
JM (81)
1/21/2005 7:01:06 PM
Reply:

Similar Artilces:

Date format issue when submitting from a userform to a spreadsheet
Hi, I have a userform that I've generated which routes dates onto a spreadsheet based on the users input. I am having a bit of a frustrating time with the dates, it would appear that in the process of moving the date from the userform to the spreadsheet some dates are switched/transposed. I'll give an example. If someone enters 09/02/2004 on the userform excel seems to look at 09 and assume it is a month and transposes the dates to 02/09/2004(this does not appear to be a US/UK format issues as I have already gone down that road). However, if the date 13/09/2004 is entered i...

Exporting file names to an excel spreadsheet.
I have a folder containing many many many .pdf files. Is there a way to export the filenames of these .pdf files into an excel spreadsheet? If this is a dumb question, I apologize. I didnt have any luck searching for the answer here. -- Kepf ------------------------------------------------------------------------ Kepf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30611 View this thread: http://www.excelforum.com/showthread.php?threadid=547520 I use Jim Cone's fine Add-in called "ListFiles"for this sort of thing. It's available free (a...

How to get XML data out of an XML file
I am trying to retrieve the Parameters first or second (0, 1 ,2) node from the following XML file: <?xml version="1.0" encoding="utf-8" ?> <Robot xmlns="http://tempuri.org/RobotDefaults.xsd"> <Parameters> <Name>Decker</Name> </Parameters> <Parameters> <Name>A</Name> </Parameters> <Parameters> <Name>B</Name> </Parameters> </Robot> There will be more data than just a name for each Parameters node. Here is my code: Dim node As XmlNode = xmlDocument.SelectSingleNode("/P...

Publisher file made in Publisher 2007 won't open in 2007
I produced an 8.5 x 11 brochure two days ago in Publisher 2007. I was able to save, resave and reopen the file many times during the day. When I tried to open the file today, I get the "Publisher cannot open the file" error message. I've tried to open the file on two different machines with Publisher 2007 and get the error message both time. One has XP Pro, the other has Visa Home Basic. It's a 1.6 meg file. I have a smaller publisher file of a bumper sticker (40 kb) which was made a couple of weeks ago which opens with no problem. This is the second time I ha...

Multiple PST Files #2
I am running Outlook 2003 and would like to have Outlook use two different .pst files (one for my work stuff and one for home) on the same computer. Is it possible to do this? If so, can I can I configure one of the pst files to get e-mail from one account, while the other pst file is configured to get mail from the other account? Thanks! -D Yes, you can create multiple PSTs. I keep mine stored in the same file location but with different names. Depending on which version of Outlook you run, you can creat a new pst from file/new/Outlook Data File (I run Outlook 2003 but had multiple P...

Money 2006 file repair application error
I cannot delete an old account because I get a "file may be courrupt" error so I am trying to repair my 2006 file. Following the deirections, when the progress bar almost completes, I get an application exception and send an error report to MS. My event log has 2 app errors 1) Event Type: Error Event Source: Application Error Event Category: None Event ID: 1001 Date: 4/12/2006 Time: 10:47:26 PM User: N/A Computer: xxx Description: Fault bucket 02266399. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 42 75 63 6b 65 ...

Application hanging on file load...
Okay, I'm having the strangest problem, and I'm hoping somebody here will be able to give me an idea of how to attack it... I have an MFC application that does some networked communication, multi-threading, fun stuff... I also load and save xml configuration files. Now, on most of the computers I've run my software on, I have absolutely no problems. On SOME boxes, however, whenever I use my menu to try to load or save a file... before the File Dialog box even comes up... the application hangs. All the boxes I've tried this on have been Windows 2000 boxes with Service Pack 4....

can't open files
I have Microsoft Office 2003 ~ all of a sudden when I go to my documents and try to open a file, I get this message "problem sending command to the program". Error 0646 and dt000 See the article "How to re-register Word when problems crop up opening files” at: http://www.word.mvps.org/FAQs/AppErrors/ReRegisterWord.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Lost in Vegas" <Lo...

Error saving a Shared Workbook
I have a user using a shared workbook and gets an error everytime she does this ONE specific change. She deletes a line and then saves and gets a message that says, "EXCEL.exe has generated errors and will be shutdown by Windows... blah blah blah". If she makes anyother type of changes it saves just fine. I also had another user do the SAME change and that person also got that error message. When the file is changed to "Not Shared" then the line is deleted it saves fine also. The problem is obviously with the file itself and that is shared out. can anybody ...

Issues Template
Hi i have downloaded the issues template to work in a vet office, but am not sure what the Add related issues is for on the Issues details form. i jus want to know what it does and its benefits It's unlikely that you'll get any help that requires anyone to download and analyyse someone else's guickie application. You'd do better to use the sample databases and tools that are provided with Access and ask questions based on them, instead. HTH -- -Larry- -- "Amin" <Amin@discussions.microsoft.com> wrote in message news:1B20F4FC-2696-4724-8615-49...

I can no longer convert my files to pdf
I have Publisher 2003 and yesterday, my pdf menu on the top left disappeared and I can no longer convert my Publisher files to pdf. I've even uninstalled/reinstalled the Adobe Acrobat 7 and have also updated to 7.8 but still no luck. The next step was to uninstall and reinstall Publisher and still no luck. Any one know what may be the problem? Thanks. How are you trying to convert your files? When happens when you try? -- JoAnn Paules MVP Microsoft [Publisher] "darrellm" <darrellm@discussions.microsoft.com> wrote in message news:A78B7B52-981D-4FB7-8625-EAD9...

Outlook Data Files #4
I've done some reading but I'm still confused about the use of Office Outlook Personal Folders File (.pst) versus Outlook 97-2002 Personal Folders File (.pst). I understand the basic "Office Outlook Personal Folders File (.pst) to create a new Outlook 2003 .pst file. Click Outlook 97-2002 Personal Folders File (.pst) to create a new Outlook .pst file that is compatible with earlier versions of Outlook." When we have upgraded to Outlook 2003 or set up a new PC with Outlook 2003, when adding PST's you can chosse either of the two file type options and browse to chos...

Backup Excel file
I want to take backup of a file every time. I am using - save as - tools - general option - always create back up. The backup file is in the same location but I want to put it in a different folder. What should I do, kindly suggest. Thanks Jan Karel Pieterse's has an addin called AutoSafe (note spelling). http://www.jkp-ads.com/Download.htm (look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.) It doesn't overwrite the existing workbook when it saves. It saves to a user selectable folder. And when it's done, it either deletes these backups (or puts them...

Utility (pref. script) to catalog .EDB files
Hi, I have a client that is using an Enterprise backup tool which, whilst able to back-up and restore, does not provide in-depth information like traditional Exchange-aware backup products. I have been asked to write a script to list the users in a flat .EDB file (which has been snapped and copied and flushed using SAN replication tools). I have taken a look at the ESE API, which can only be accessed using C + (I only use VB). Other than EXMERGE, does anyone know of any tools that allow you to list the basic mailbox details on a EDB file? Thanks, Hutton. ...

List folders to file
Hi Does anyone have a macro that would list all the folders (with path) and subfolders to an excel sheet but not the files? Thanks Shona Shona- There's a function called CELL() that should return your filename (or any of a number of parameters) but I can't get it to work properly on my machine, so I can't make it work for you. The syntax is =CELL("filename") which ought to return the path and filename of the current file, and which you could then trim down to show just the path. Can anyone provide some guidance here? Dave, If it isn't working for you, it pro...

Hyperlink File Help
I am needing some major help. I have a file with hyperlinks in column F that link to a file on our server. I am needing to test to see if the file exists and if it does, copy the file to a folder in my documents called (CapturedFiles) and if it doesn't format the cell color to red. Can VBA do this and if so how? Any help would be greatly appreciated. Thanks in advance. Fileserver or webserver ? Tim On Nov 23, 7:20=A0am, Aaron <Aa...@discussions.microsoft.com> wrote: > I am needing some major help. =A0I have a file with hyperlinks in column = F that > l...

IMPORTING MONEY FILES DUP ENTRIES
I have been unable to run money98 files in money2003.Tried importing files but all tranfers between accounts are duplicated. Don't understand how to import all the accounts at once. I created new accounts in 2003 and imported one by one, but any transactions between accounts is duplicated. Follow the prompts on the import file dialog that tell you to select multiple files to import at the same time. There are other guidelines if investment accounts are involved. You might want to review postings on this subject in the group archives at http://groups.google.com. "JAYNE" &l...

Lost .pst files
I am using Office XP with Outlook 2002 (SP2). I recently had a boot track failure on my old computer which had 2 hard drives, using the second drive as back-up storage. I bought a new computer and installed the old main drive (the one with the failed boot track) in my new computer as a second drive and copied all the data onto the new main drive. All data and software works except Outlook. I cannot find any .pst files on my old drive. Where could they be. BTW I use Matadore as a spam blocker. In article <014e01c3462e$561cbdf0$a101280a@phx.gbl>, daddyray01 @sport.rr.com say...

Read file info using SMO locks database!
Hi! I'm using SMO from C# to restore a database from a backup file. Since I want to re-use the same datafiles I try to read the datafiles in my destination database and call RelocateFile to use these filenames during the restore. Everyting works fine except when I try to read the current datafilenames (see code below). If I skip this code and just hardcode the paths in relocatefile everything works fine. Database db = svr.Databases[destinationDBName]; foreach (FileGroup group in db.FileGroups) foreach (DataFile file in group.Files) Console.WriteLine...

Work spreadsheet issue
If I have multiple rows of data on a worksheet and on another worksheet I want various counts of rows that have certain things in common, how would I do that? Thanks. -- jenrenea ------------------------------------------------------------------------ jenrenea's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23098 View this thread: http://www.excelforum.com/showthread.php?threadid=373900 Can you provide a sample of your data along with your expected results? -- Domenic ------------------------------------------------------------------------ Domenic's...

protecting shared workbook
Hi , I need to protect a shared workbook - other users within the office need to be able to neter data however do not seem to be able to do this withough reformatting column widths etc (we have some weird and wonderful people here) I have tried tried what i though would work - tools - Protect Sheet - then deselecting format cells, format columns, format rows however this also prevent users from enetering data. Any help appreciated. Try unlocking just the cells that are used for data entry: Select just the cells that you use for data entry. 'Format' menu --> Cells --> Pro...

Macro on a protected worksheet in a shared workbook.
Hi, I have a macro in protected worksheets that can't run once the Workbook is Shared. I have wrapped the Macro code so as the worksheet is unprotected for the time the Macro runs, and unable the Autofilter. The code is as follow at the moment: Sub Newaction() Sheets("Critical Path").Unprotect ("") ' Newaction Macro ' Macro recorded 17/11/2004 by Clifford ' ' Selection.AutoFilter Field:=1, Criteria1:="=" Sheets("Critical Path").EnableAutoFilter = True Sheets("Critical Path").Protect contents:=True, userInter...

hide/close/delete shared account
(bear with me. i'm new and although this is my second time trying to set up money, i've run into the same problem and have yet to find the answer in the forum.) i have four bank accounts and one is shared with a family member. i don't want this account to show up at all in money essentials. i tried "closing" it. i tried "hiding" it. i tried "deleting" it. but each time i go back to "categorize my transactions," transactions from that account are still there. The problem here is that Money is designed (and Money Essentials (MEss) even ...

Sharing Violation 04-30-10
I have a strange problem that started happening a month or two ago. Periodically my Vista and Win7 users are getting a sharing violation in Excel 2003 when attempting to save the file they have been working on. The file cannot be saved when this happens, but Excel creates a copy of the file that is named (seemingly randomly) something like "10D8D000" that can be saved to another filename. Essentially the original file must be deleted and the new file renamed back to what the original file was named. This is obviously very irritating (we use Excel alot), so I was want...

Hyperlink To JPG File
I have added a hyperlink to a jpg (photo) file, and when i select the hyperlink, the jpg file opens in Corel Photo-Paint. Is there a way that I can force it to open with Windows Photo and Fax Viewer, Instead. Thanks GW Open Windows Explorer and find a *.jpg file. Select it and right-click and "Open With" Make Windows Photo and Fax Viewer the default "always open with". If you get an error, you may have to open Corel Photo-Paint and disassociate *.jpg files using probably some Options setting. If neither of these steps work for you, in Windows Explorer>Tools>...