+ Reply to Thread
Results 1 to 2 of 2

Letter substitution in a pivot table

  1. #1
    Registered User
    Join Date
    05-14-2015
    Location
    Augusta, GA, USA
    MS-Off Ver
    2010
    Posts
    1

    Letter substitution in a pivot table

    Have a spreadsheet with a data table and multiple pivot tables. On one pivot table sheet, Excel is substituting the letter i for h, but only on the first row field. The pivot table has three fields for the rows, but only one of these has the substitution problem. I duplicated the pivot table on another sheet and the problem does not exist on that table. There are also two other sheets with pivot tables that use the same data table which do not have the substitution problem. After looking at every configuration option and field setting, I cannot find anything that might explain such behavior. Any thoughts?

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Letter substitution in a pivot table

    Hello,

    hard to tell without seeing the file. If you duplicated the pivot on another sheet, and it does not show the problem, why don't you just delete the faulty one and use the new one?

    cheers, teylyn

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  2. Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table
    By ragavendraph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 03:00 PM
  3. UNC Path For Pivot Table Defaulting to Drive Letter
    By Kyle123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2011, 05:21 AM
  4. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  5. Return pivot table range...not the data table, the PIVOT TABLE!
    By Air_Cooled_Nut in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2008, 01:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1