I have setup a workbook so that I can have a user compile a simple report. I have 3 worksheets each of these are SAP Business Warehouse queries. The third sheet also contains rather simple formulas at the right of the data (ie lookups referring to the other two sheets). These formulas appear to be fine and appear without error. I have a 4th pivot table sheet that places certain colums in a specific order. The issue I have is when the other user refreshes the pivot table, 3 columns show "#NAME?", however when I refresh the pivot from the same file the refresh works fine....i'm stumped! I have removed the issue of versions because I have refreshed the reports in both excel 2002 and 2007 and I get the same results. The user only users excel 2002 Appreciate any assisance! chumpy
Hard to say without seeing the formulas, but is it possible you have used any formulas from the analysis toolpak, and the user simply doesn't have it installed perhaps? If you do have it installed then try taking off the AT addin and see if you then get the same issue. Failing that do you have any SAP specific Excel addins that the user doesn't? Either way it sounds like you have something the user doesn't. Is it just the Pivot table that shows #NAME (Can't see how to be honest), or is it the source data that shows it as well. if so then post back with examples of the formula from each of the columns showing #NAME, and it may give us a clue. Not sure it is a full list, but any of the following will require the user to have the AT else they will get #NAME ACCRINT ACCRINTM BESSELI BESSELJ BESSELK BESSELY BIN2DEC BIN2HEX BIN2OCT COMPLEX CONVERT COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CUMIPMT CUMPRINC DEC2BIN DEC2HEX DEC2OCT DELTA DISC DOLLARDE DOLLARFR DURATION EDATE EFFECT EOMONTH ERF ERFC FACTDOUBLE FVSCHEDULE GCD GESTEP HEX2BIN HEX2DEC HEX2OCT IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSIN IMSQRT IMSUB IMSUM INTRATE ISEVEN ISODD LCM MDURATION MROUND MULTINOMIAL NETWORKDAYS NOMINAL OCT2BIN OCT2DEC OCT2HEX ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD PRICE PRICEDISC PRICEMAT RECEIVED SERIESSUM SQRTPI TBILLEQ TBILLPRICE TBILLYIELD WEEKNUM WORKDAY XIRR XNPV YEARFRAC YIELD YIELDDISC YIELDMAT Regards Ken......................... "chumpy" wrote in message news:F7093BDD-3E9E-4164-8591-CCE6848BEB6B@microsoft.com... >I have setup a workbook so that I can have a user compile a simple report. >I > have 3 worksheets each of these are SAP Business Warehouse queries. The > third > sheet also contains rather simple formulas at the right of the data (ie > lookups referring to the other two sheets). These formulas appear to be > fine > and appear without error. I have a 4th pivot table sheet that places > certain > colums in a specific order. > The issue I have is when the other user refreshes the pivot table, 3 > columns > show "#NAME?", however when I refresh the pivot from the same file the > refresh works fine....i'm stumped! > > I have removed the issue of versions because I have refreshed the reports > in > both excel 2002 and 2007 and I get the same results. The user only users > excel 2002 > Appreciate any assisance! > chumpy
The ATP functions became worksheet functions in 2007, and the OP reported the same problem in 2007. Likely the formulas are expecting an Add-In that is not present. Jerry "Ken Wright" wrote: > Hard to say without seeing the formulas, but is it possible you have used > any formulas from the analysis toolpak, and the user simply doesn't have it > installed perhaps? ...
Hi Jerry, long time no see - Hope all is well with you and yours. The way I read the OP (possibly in error of course) was that the Sys Admin was having no issues and that the Sys Admin had tried using it in both 2002 and 2007 with no error, but that the User he was trying to help only had 2002, and was the one with the error. That left it conceivable I think that the admin may well have had the AT present in his version of 2002, and wouldn't have needed it in 2007. The user with only 2002 I figured was a good candidate for no AT, or as we said some other addin. Best Wishes Ken........................ "Jerry W. Lewis" wrote in message news:74119E9E-16B8-47E5-A836-33C571A8E918@microsoft.com... > The ATP functions became worksheet functions in 2007, and the OP reported > the > same problem in 2007. Likely the formulas are expecting an Add-In that is > not present. > > Jerry > > "Ken Wright" wrote: > >> Hard to say without seeing the formulas, but is it possible you have used >> any formulas from the analysis toolpak, and the user simply doesn't have >> it >> installed perhaps? > ...
