Bugs

Excel 2013 v Excel 2010 Speed Test

There are a lot of good comments on the Excel 2013 Is Unreasonably Slow post, but none of them worked for me. Even a generous offer from keepItCool, but I can’t send the problem child due to proprietary information. So I’m trying to demonstrate the problem in a simpler fashion. Sub TestTimes()      

Read on »

Excel 2013 VBA Unreasonably Slow

I’m not the kind of guy to upgrade too soon. I spend a lot of time in VBA, so new features in Excel don’t generally inspire me. Recently a client of mine upgraded to 2013 with, let’s say, disasterous consequences. First, there’s the Single Document Interface (SDI). That’s where every document is in it’s own

Read on »

Learning from my Errors

There’s an annoying bug in VBA whereby if you’re trying to change the .visible status of a PivotItem, and if the PivotField had a number format set to General, and if you live in New Zealand, then you’re out of luck: If you live in the US however, you’ll be fine. No error for you.

Read on »

Wonky Keyboard Shortcut

Check out the keyboard shortcut for the Reapply button. I don’t think I’ve ever used that button. If I need it, I think I’ll just use the mouse. Even I have limits.

Read on »

Indecent Add-in Exposure

Every so often, for reasons I can’t explain, an add-in shows up in my Excel UI. Today it was BlogHelpers.xla, but other times it’s different. It’s always in a non-maximized window view. That is, the workbook name is in the window’s title bar and not the application’s title bar. You can see that the IsAddin

Read on »

A date with PivotItems

Howdy, folks. Jeff here again. I’ve been sharpening up some code to manually filter a PivotField based on an external list in a range outside the PivotTable. It works blazingly fast. Unless there’s dates as well as non-dates in my PivotField. In which case it errors out. Try this: Put “Pivot” in A1 Put =TODAY()

Read on »

PivotItems Are Wrong when Calculated Field Is Present

I have a procedure where I loop through a pivot table and create a general journal entry to be imported. I used the same procedure to create another journal entry, but with one change. For this new journal entry, I wanted to round all of the amounts to the nearest $10. They were estimates and

Read on »