Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse by Tags

  • WTF

    I don’t know where to start with this one. To recap, I have two variables dimmed as Double. They both apparently equal 37,089.60, but they don’t equal each other. What’s the next step? Read More...
  • Margins Don’t Fit Page Size

    I got the error message “Margins Don’t Fit Page Size” when I tried to Print Preview after setting the scaling to Fit to 1 pages wide by 1 tall. At 100% scaling, the spreadsheet took six pages to print. But at 1×1, it took 12,438 pages to print. Here’s Page Break View: I [...] Read More...
  • Problems related to KB973475 and KB973593

    Hi All, Many users (including customers of mine) have experienced trouble with two recent security updates by Microsoft, see: http://support.microsoft.com/kb/973475 and http://support.microsoft.com/kb/973593 There seem to be two hotfixes to this problem: KB973475 Excel 2003 hotfix package : http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=978908&kbln=en-us KB973593 Excel 2007 hotfix package : http://support.microsoft.com/default.aspx?scid=kb;EN-US;978522 If you experience problems with...
  • Navigating Protected Sheets

    In Excel 2003, I was happily moving from sheet to sheet using Control+Page Up/Page Down. Suddenly it stopped working. Instead of moving to the next sheet, I was scrolling one page to the left/right with those key combinations. I couldn't get off of this particular tab without clicking on another one with [...] Read More...
  • The Mystery of the Disappearing Range Name

    Hi all, As some of you may be aware, Excel 2007 has been exhibiting an obscure but very annoying bug. On some rare occasions, Range Names may disappear from your workbook after saving it. I have never been able to detect any pattern in this behaviour, it just happens on and off. I’m happy to say Microsoft created [...] Read More...
  • Hidden Columns in HTML

    When I save my Excel workbook as a webpage, my hidden columns are no longer hidden when viewed in Firefox. It seems to be OK in IE6. I unhid the columns, turned the font white, made the columns thin, and it seems fine. I know some of you are against white-font-on-white-fill hiding, but I think [...] Read More...
  • Google Toolbar Slows Excel

    This report comes from Charles Williams of DecisionModels.com fame. Charles knows a thing or two about performance in Excel. For the last few weeks I have been trying to find out why clearing a large range of cells caused Excel to hang on some PCs but not on others. This does not happen with Excel [...]
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.