dan_l
Active Member
Ehhhh: I hate this. I have to send a 'simple' dashboard to somebody. Trouble is, I have no idea what version of excel they're using. I don't really know them from Adam, nor me them so I've intentionally not used VBA. I don't even know what version of Excel they're using, but it's reasonable to assume 03.
So my question: How does the 07 to 03 compatibility thing work? I know it's "double click and excel does some stuff", but does anybody know exactly what happens? What steps do I need to take to ensure this thing works without a snag?
Some specifics:
I used sumifs. Should I change this to sumproduct just to be sure?
How about getpivotdata? I know the syntax slightly changes between 03 and 07, but I've never tried using gpd in 07 and moving it over to 03.
Finally: anybody have a copy of 03 live on their pc this weekend to give it a quick test?
So my question: How does the 07 to 03 compatibility thing work? I know it's "double click and excel does some stuff", but does anybody know exactly what happens? What steps do I need to take to ensure this thing works without a snag?
Some specifics:
I used sumifs. Should I change this to sumproduct just to be sure?
How about getpivotdata? I know the syntax slightly changes between 03 and 07, but I've never tried using gpd in 07 and moving it over to 03.
Finally: anybody have a copy of 03 live on their pc this weekend to give it a quick test?