Show custom messes up my FREEZE PANE

When I use VIEW->Custom and any views I created, sometimes when I do a SHOW
ALL, my FREEZE PANE is really messed up! Some times it will be off the
screen and I can not get to the data at all until I UNFREEZE, and then I can
reset the FREEZE PANE. I always only lock my HEADER row.

Any ideas how to resolve this? What causes it?


Thanks
Bruce


0
BruceJ
10/29/2003 10:23:01 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
402 Views

Similar Articles

[PageSpeed] 26

Reply:

Similar Artilces:

How to convert hyperlink in Excel to show hyperlinked address?
I have an Excel spreadsheet with a list of hyperlinked email addresses. For example the list displays "Email", but the hyperlinked data is "mailto:name@domain.com". I need to "un-hyperlink" the information so that I have a list of the data itself - i.e. so I have a list of the name@domain.com addresses. Using Excel 2003. Thanks for any help you can provide! IN EXCEL 2007 (maybe 2003 but not sure) / right click the cell and select Remove Hyperlink. If my comment has helped please hit Yes. Thanks. "Bruce" wrote: > I have ...

Customization: disabling built in features
I would like to disable/remove some of the sections on the left hand side of CRM. For example, on the home screen I would like to remove the Invoices section since we don't use these. And on the Account level I would like to remove the Notes and Contracts sections for the same reason. Is this possible? Keith ...

text in cell shows up as ####
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Text in cells in a coumn shows up as ####, apparently because there is a large amount of text. When I mouse over, the text shows. It also shows up in the formula bar. How can I copy and or print the text in these cell? <br><br>When I try to save these cells as text and transfer to Word, they continue to print as ###. text in cell shows up as #### <br> I am totally new to this whole environment! A new iMAC and this software. <br> However, in trying to learn how to use EXCEL, I found that...

screen freeze after long time running
Hi I have a program written in Microsoft Visual C++ .NET . Its interface is based on CFormView. It includes three tabs to show information and plots. The plots are made by BitBlt() which copies data from the vectors to the screen around every 5 minutes. The problem is that after the program runs continuously for more than 3 days the screen freezes. Nothing is updated. I have to minimize the window and it may return to normal look. Some static labels on the interface also freeze or appear strange look. Does anyone have similar experience ? Thank you for your hints or suggestions! <e...

Filtering data by custom fields in pivot tables from Visual Report
I have recently upgraded to MS Project 2007 and like the visual reporting feature, except I really need to filter and group the resulting pivot table in Excel by custom fields. For example, for task usage, I cannot filter my pivot table to show only the tasks that have costs > $0, thus my table ends up showing too many lines and a lot of 0's. I would also like to group by department/ function which I put in a custom text field. How do I do this? I saw related posts about saving the file as an Access database and then creating the pivot table by connecting to the datab...

Keeping Custom Properties When Forwarding or Replying to a Message #2
We have emails saved on the file system, that is kept track of by another program. These emails have custom properties attached to them. There is no custom form, just custom properties. These fields were originally added using objPost.UserProperties.Add. We need it so that when someone opens up one of these emails through the file system, and then replies or fowards the message, these custom properties are kept in the reply. This is so the external program can track these emails. Is there a way this can be done? We could have these emails opened up using an Outlook command line that i...

How do you define a custom paper size in Excel? (i.e. 11x17)
How do you define a custom paper size in Excel? (i.e. 11x17) Hello- Excel doesn't provide for custom paper sizes, but most any size appropriate for Excel output is already provided _if_ the installed print driver supports it. Go to File>Page SetUp--Page and open the list of sizes. If your installed driver supports 11x17 it will be in the list (although it may be listed as 'Ledger' rather than by dimensions). HTH |:>) "Marcin Rembisz" wrote: > How do you define a custom paper size in Excel? (i.e. 11x17) ...

Customized Task Views Have Disappeared (Take 2)
I was having an issue similar to this original post and followed the instructions given. It worked, but as I have worked with it I have found that it will restore my customized Task views but not my customized Contact views. I can change some of the Send and Receive setting and it will restore the Contact views but not Task views. Somehow I am searching for a way to restore both Task and Contact views. Any ideas? -- Tia, Education and Documentation Specialist Sorry, i posted this in the wrong discussion group. I have posted this correctly and my question has been answered. -- ...

CComboBox shows only one item at a time !
Hi All, I am using CComboBox control and have tried both dropdown and dropddown list styles. The problem is that I have several items in the combo box but dropdown shows only 1 at a time (i.e. the arrows of v-scrollbar are stuck together).. How do I remedy this ? Thanks in advance. Ashish Got it... Thanks "Ashish" <abc@def.com> wrote in message news:eqRb$LSyDHA.2304@TK2MSFTNGP12.phx.gbl... > Hi All, > I am using CComboBox control and have tried both dropdown and dropddown list > styles. The problem is that I have several items in the combo box but > dropdown sho...

Outlook 2007-exchange issue..inbox doesn't show new mails when offline!
Hi I have outlook 2007 (Beta 2) installed and I connect to my office exchange server(2003) as well. Incoming mails from internet get routed to my local pst. Mails from exchange server keep sitting in my exchange mailbox-inbox, which I manually copy to my pst inbox (as is a known issue with Beta 2). Yesterday, for the first time I downloaded mails from home. Outlook downloaded all mails and the unread mail count increased....however, it just wouldn't show the new mails received. All it showed was my earlier mails downloaded while I was still connected to exchange server. Now I came to wo...

Report to show totals for each day of month
Greetings, I have an Excel spreadsheet that I use to capture: Column A) Day of the month (1-May, 2-May, etc.) Column B) How many clients were in residence on each day (Occupancy) Column C) Total Capacity (27) Column D) Shows a "1" if the Occupancy is 90% or more of the Total Capacity, else "0" The Totals row shows: Column B) The average Occupancy for the month Column D) Totals the times there is a "1" in Column D Is there a way for me to capture this data in a Report? I've got a query set up that uses these expressions: For AdmitDate: <=[Dat...

Creating Custom Dialog Boxex (Popup)
Hello, I am trying to create a custom dialog box that will allow me to have the user clarify an entry when a checkbox is checked. I want them to be able to select something from a list that I have created. I have created the popup in Excel but cannot find out how to call the popup into the display when the checkbox is checked. Can anyone help me please? Is this a checkbox on the worksheet? If yes, then if it's a checkbox from the Forms toolbar, assign this macro to the checkbox: Option Explicit Sub testme() Dim myCBX As CheckBox Set myCBX = ActiveSheet.CheckBoxes(Appli...

How to "freeze" chart & separate it from it's Data
I would like to produce a chart and then rearrange the data to produce a separate chart. Is there a way of separating a chart from it's data so that I can take the data and after rearrangement, produce another chart? Hi, Here is some information on how to de-link chart and data. http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Rooky228" <Rooky228@discussions.microsoft.com> wrote in message news:4B519787-DF2D-4C1C-B941-DBC1FD054184@microsoft.com... >I would like to produce a c...

Sent items from Blackberry 9700 not showing properly in Entourage sent items
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Email Client: Exchange Hi, <br> I am really happy using my entourage but whenever i send an email from my bb bold 9700 it appears in an unreadable format in my sent items. below is an extract on how an email i sent from my bb is displayed in my entourage sent items: <br><br>X-MimeOLE: Produced By Microsoft Exchange V6.5 <br> Received: from 68.171.239.150 ([68.171.239.150]) by mailserver2.beirut.leoburnett.com ([10.248.224.4]) with Microsoft Exchange Server HTTP-DAV ; Fri, 28 May 2010 20:03:13 +0000 <...

Create or find "Favorite Folders" pane
I can't find the "Favorite Folders" pane above "Folders List", anymore. If you're using the Folder List then the Favorite Folders section won't appear. "ChristiA" <ChristiA@discussions.microsoft.com> wrote in message news:CEC82608-6F53-4269-9799-61D3DF7374E1@microsoft.com... >I can't find the "Favorite Folders" pane above "Folders List", anymore. ...

How do i insert symbol in custom footer
I'm working on Excell 2003 I've been asked to create a custom footer in the left column i have to insert Copyright © 2003. I can't figure out how on earth to insert the symbol if anybody out ther knows could you please let me know Thanks Den one way is to use Insert | Symbol and select the � character and copy it before you go to View | Header and Footer. Then just use Ctrl-V to paste it in the Footer Regards Trevor "Den" <Den@discussions.microsoft.com> wrote in message news:E3AEFB2C-FBF9-4395-95A1-6ECDD7415DAA@microsoft.com... > I'm wor...

blocks of customer database missing
We are running RMS 1.2 and have noticed over the last month a number of customer missing when looked up they mostly seem to to be recent additions from the last few months there are some that are one or 2 missing then there are several with anywhere from 60 -130 in a row missing. there customer records are just gone the customer numbers are sequential and as a block they dissapear. the only other thing we have. noticed is several customers suddonly have duplicate customer numbers when corrected manually it seems a few days later the duplicate is back. We tried to manually recreate this ...

>>>Customer Live Chat Thursday Aug 2nd: Inventory Management <<<
Microsoft Dynamics RMS - Inventory Management Thursday Aug 2nd 10:00am PST Have questions about managing your inventory in Microsoft Dynamics RMS? Want to learn more about item types, tracking inventory, purchasing, or the new matrix item features? Chat with Retail Management System feature experts about these or any other inventory issues. Sign up: http://www.microsoft.com/communities/chats/default.mspx -- This posting is provided "AS IS" with no warranties, and confers no rights. ...

navigation pane
How do I limit the text within my document map to only show headings? Currently, my headings are showing, but some text formated as "normal" or "body text" within my document also shows up in my document map. Even when I right click and choose "show heading 3" (for example), the normal text still appears. If I highlight the problem text within my document, and click on "normal", it will disappear within the document map, but next time I open the document, it will have reappeared. Any help would be appreciated! I can't answer until I know what applic...

Search freezes
Windows XP SP3 When I make a search from Start > Search it list a number of files but does not close and freezes. I have to shut it donw in the Task Manager. If I right click the drive ans Search I get a higher number of files and all OK. ...

Run script from Entity Toolbar Custom Button
I have added a button to the Opportunity Entity toolbar and what I'd like to do is get it to run the change event script on one of the fields on the Opportunity form. I can't seem to get this to work using: JavaScript="crmForm.all.fieldname.FireOnChange();" Presumably this is because crmForm isn't the Opportunity form. Is there any other way I can do this? -- CB ...

Preview pane sluggish
Recently the preview pane in my e-mail takes a good 5+ seconds to catch up with the message i select. any reason for the slow down? any suggestion? E-mail me with any ideas. J If you have Outlook 2002, go to Tools -> Options -> Other and turn off Instant Messaging integration. -- Jeff Stephenson Outlook Development This posting is provided "AS IS" with no warranties, and confers no rights "Jake" <jbell@nl-law.com> wrote in message news:03bb01c35dfb$8b8e7750$a301280a@phx.gbl... > Recently the preview pane in my e-mail takes a good 5+ > seconds to ca...

Outlook 2002 doe not deliver, shows messages being sent...
I intermittently get the following when trying to send out messages: "The recipient was unavailable to take delivery of the message" with a reference to our domain ending with "3499 Host unreachable". I've looked everywhere for help but cannot find anything. I installed SP1 for Outlook 2002, no luck. Note: it is NOT consistent. Sometimes things actually get sent. ...

How to show gridlines
I have a spreadsheet another person sent me. It does not show the gridlines and I need the gridlines to be visible. I tried Tools, Options, view, etc. Help! The cells may be filled with white colour! Select all the cells in the sheet, by clicking on the square to the left of the column letters, and at the top of the row numbers, then: Format > Cells > Patterns tab > 'No colour' > OK. See if that helps George Gee "Horsingaround" <Horsingaround@discussions.microsoft.com> wrote in message news:07531D0C-E55A-4EEC-B576-275A85B3BCA7@microsoft.com... >...

Wrong transfers showing up in report
I am using Money 2004 Small Business on a Windows XP Pro system. I have rental property and have setup two top level categories in Money to track the income and expenses (with several sub-categories to break out rent, taxes, insurance, etc.). I ran an Income/Expense report and just selected those two categories and also selected the "Include Transfers" option to account for the amount I am paying down the loans by. The problem is that it pulls in transfers to several other loan accounts that have nothing to do with this property. Why is it pulling them in and how do I get t...