Yesterday Rob Collie made a post on his blog about sizing considerations for PowerPivot implementations on Sharepoint. The main thrust of the post was directed at end users and making sure that their server farms have adequate resources to efficiently
I am an information worker. A big part of my job is to provide our staff and team members with useful information so that they can perform better in their jobs roles. In addition to this, as the Controller of
I was playing a version of 21 with my daughter this weekend, and mentioned Blackjack to her. After a few questions, I thought it might be entertaining to build a version of Blackjack for her to play so I did.
I was working on a little application which has a spin button on the worksheet. That spin button is linked to a cell and works just fine for my purposes. After a while though, it became apparent that I needed
I had an email exchange with Charley Kyd tonight, and I was bemoaning the fact that I couldn't link my Excel chart titles to a range. I could have sworn you could do this, but not working with charts a
Background I've been pretty up front with the productivity gains that I saw when I embraced VBA years ago. In fact, my About Me page on my website spells it out pretty clearly: In the fall of 2002, the resort's
I have a financial model that I set up using a grouping in some key places so that I could collapse sections of the model when I didn't want to look at them. As I was handing off the model
Today I realized that one of my GETPIVOTDATA formulas was returning an error, since there wasn't any result in the Pivot Table it was checking for data. Unfortunately, during the design of the spreadsheet I never wrapped the function with
I know it's been forever since I've blogged here, and I'm sorry to have to revive this with a rant, but… I was writing an article up for how to customize the Office Ribbon in Excel 2010, and thought I'd
Dave writes: I found your excellent code to run a procedure on a target spreadsheet from an originating spreadsheet on VB Express Forum. Â It works fine if both files are on the same jump drive but fails on our work
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
