And yes, it counts towards the World Record attempt.

The Mozilla servers serving the web pages have all crashed but the files themselves are still being served.  I don’t think this is well known…

Firefox 3.0 (EN-US)

Update: Mozilla has fixed their web pages and now all of the links that, earlier today, showed version 2.0 are properly showing version 3.0.  SO GO GET IT!

Yep, it’s true.  It appears that one hand of Microsoft doesn’t know what the other is doing.  I haven’t found a lot of hits on this but apparently both sides of this bug confirm its existence and both claim it’s not their problem.

Symptom:

• Microsoft Excel cannot find the references inside a pivot table that references the same workbook when opened from Internet Explorer

Cause:

• Internet Explorer adds ‘[X]’ to the end of the file name when storing the file in the IE temp folder, where X represents an incrementing integer based on the number of downloads of the same file, and the square brackets are illegal characters for file names in Windows

Steps to reproduce:

• Browsing with Internet Explorer
• Clicking on a link to an Excel spreadsheet with a pivot table in it that references itself
• Clicking on "Open" rather than "Save"

The only solution I could think of was to write a VBA macro to rename the file and reattach all of the pivot tables.  I hope this saves someone else some trouble in the future.  When you think of me, think of me fondly…

( You’ll have to add a reference to Microsoft VBScript Regular Expressions 5.5 or better. )

 Sub Auto_Open()
    
    Dim sFilename As String   ‘ the corrected filename
    Dim oASheet As Worksheet  ‘ the worksheet object
    Dim oPT As PivotTable     ‘ the pivot table object
    Dim sTempSource As String ‘ the pivot table temporary source variable
    Dim sNewRange As String   ‘ the new pivot table source variable
    Dim reg As New RegExp     ‘ a regular expression for matching wildcards
    Dim i As Integer          ‘ looping integer
    Dim j As Integer          ‘ looping integer
    
    ‘ Set a regex to test whether this is a temp spreadsheet from IE.
    ‘ Only a temp spreadsheet from IE will have square brackets in the filename.
    reg.Pattern = "[[\]]"
    
    If reg.Test(ActiveWorkbook.FullName) Then
        ‘ the temp filename has square brackets in it
        
        ‘ just a little message telling the user what’s going on
        MsgBox "Renaming temp file and reattaching pivot tables…"
        
        ‘ The .Name property already has the brackets stripped out of it so
        ‘ we can build the new path using it and the .Path property.
        sFilename = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
        
        ‘ Now we save the file so that the assignment of source data to the
        ‘ pivot tables won’t fail.
        ActiveWorkbook.SaveAs Filename:=sFilename
            
        ‘ The range for the pivot table requires a square bracket
        ‘ just before the file name so we rebuild the path, less the drive letter.
        sNewRange = Replace(ActiveWorkbook.Path, "C:", "") & "\[" & ActiveWorkbook.Name & "]"
        
        ‘ now set the regex for the tail end of the spreadsheet, including the trailing "]"
        reg.IgnoreCase = True
        reg.Pattern = ".*\.xls\]"
        
        ‘ now loop through all of the sheets looking for pivot tables
        For j = 1 To ActiveWorkbook.Worksheets.Count
            Set oASheet = ActiveWorkbook.Worksheets(j)
        
            ‘ now loop through any pivot tables on the worksheet
            For i = 1 To oASheet.PivotTables.Count
                Set oPT = oASheet.PivotTables(i)
            
                sTempSource = oPT.SourceData
                
                ‘ go ahead and replace the invalid path with the new path
                sTempSource = "’" & reg.Replace(sTempSource, sNewRange)
            
                ‘oPT.PivotTableWizard SourceType:=xlDatabase, SourceData:=sTempSource
                
                ‘ assign the new path to the sourcedata property
                oPT.SourceData = sTempSource
                
                ‘ release the object
                Set oPT = Nothing
            Next i
            
            ‘ release the object
            Set oASheet = Nothing
        Next j
        
        ‘ Save the workbook, just to be thorough.
        ‘ Without saving a user would be able to close the workbook without saving
        ‘ and then open the workbook from the
        ‘ recent documents list and have broken pivot tables.
        ActiveWorkbook.Save
    Else
        ‘ Not a spreadsheet with square brackets in the filename
        ‘MsgBox "No renaming required"
    End If

End Sub

Has your company’s IT department locked you out of surfing the web? There may be hope for you yet.

• Open up the Windows Calculator
• Click Help –> Help Topics
• In the Contents pane on the left side of the window, right click, then select Jump to URL.
• Enter the site you wish to peruse (most likely Sears.ca ), then click OK, and away you go.

I finally upgraded my home computer, after 8 years. According to Moore’s Law my home PC was something like 64 dog-PC years old. I don’t want to go into the whole, “I remember when 8MB of RAM was enough” story but this thing was a screamer when I first got it. It was a Dell Dimension V350 making it a Pentium II, 350MHz, and I loaded it up with 256MB of RAM and a humungous 8MB AGP video card. Add a 17″ CRT monitor and I was the coolest computing kid on the block, in the year 1999. I think the hard drive was 8GB, which I couldn’t even imagine filling (even though I was downloading mp3s as fast as my dial-up connection would allow with the original Napster).

Well my new laptop, which I ordered from Sears of all places, is a Toshiba Satellite P100 MA305C. It’s got some kind of Centrino Duo processor and 2GB of RAM and an adequate video card and hard drive. There’s a good reason why I don’t know exactly what my computer is running: just about anything new these days is more than fast enough. I lost track of the advances in processor, video card and RAM speeds when they were no longer being scooped up by businesses in order to do business faster. With the exception of the newest FPS games and 3d design/CAD software, today’s computers have no trouble keeping up - with one proviso. DO NOT KEEP WINDOWS VISTA ON YOUR NEW COMPUTER!

I read a couple of reviews saying that Vista was a little power hungry but that it was beautiful. My new laptop came pre-loaded with Vista Home Premium so I was confident that my new, super-fast laptop was going to be able to handle it. Then, the day before my laptop arrived, I read another review saying that you needed at least 4GB of RAM to run Vista near the equivalent of XP Pro with 2GB of RAM. I really couldn’t believe it but I did a little more research. To add another 2GB of RAM to a notebook would cost me about the price of another whole laptop! Well, I still thought they were over-reacting. Unfortunately I was wrong.

2GB really isn’t enough to run Windows Vista Home Premium. I know, I tried. What was truly amazing was to wipe the hard drive, put XP Pro on and watch the machine fly. It was like two different computers.

While I was trying out Vista I purchased Norton 360. My goal was to be sure that this home PC would never see a virus or spyware and be backed up on a weekly basis. 360 promises to do all of those things in one neat package. The first install went great and everything was pumping along just famously, until the first LiveUpdate. After that, everything went to hell. Nothing would update, uninstalling and reinstalling didn’t fix it, Norton chat support couldn’t help me, I was stuck. Thankfully the motherboard went on my brand new laptop (there’s a funny sentence). When I got it back I put XP Pro straight on and gave Norton another chance. Same problems. Nothing would update properly. This time, though, the steps given to me by the chat support DID fix the problem and I’ve been running problem-free since then - and I actually like it. Unfortunately, I think most people would have given up long before I did. I wasn’t about to let nearly $100 go down the drain.

Bottom line? Vista is definitely NOT worth the upgrade. Norton 360 is actually pretty useful, if you can get past all of the initial bugs.