+ Reply to Thread
Results 1 to 2 of 2

(DELTE THIS THREAD PLOX) Getpivotdate ref error

  1. #1
    Registered User
    Join Date
    10-12-2014
    Location
    USA
    MS-Off Ver
    15
    Posts
    11

    (DELTE THIS THREAD PLOX) Getpivotdate ref error

    I keep getting ref errors, no matter how I try to play with the function's parameters.
    Here's a screenshot.
    And the file itself.

    As you can see, I'm trying to report the number of discharges per state, in the "States" sheet.

    p.s. the problem was with the column names, turns out the "Total Discharges" have an excess space at the end of its name, and there are some other issues with names. So I simply renamed the columns in the "HospitalData" sheet, then recreated the table, and now it works!
    Last edited by dramadeur; 10-12-2014 at 09:26 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,023

    Re: (DELTE THIS THREAD PLOX) Getpivotdate ref error

    Hi, welcome to the forum

    Thanks for sharing the solution with us Trailing/leading spaces is a common cause of problems like that
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. [SOLVED] Run-tim error -2147467259(80004005): Automation error Unspecidied error
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2014, 12:12 PM
  2. Excel macro (compile error. syntax error.) error
    By salar_younis in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-06-2014, 06:11 AM
  3. Error "run-time Error '1004': General Odbc Error
    By D4WNO77 in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-16-2012, 09:55 AM
  4. Error 75 File/Path access error, sometimes Error 1004
    By smokebreak in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-16-2011, 02:35 PM
  5. Error Handling - On Error GoTo doesn't trap error successfully
    By David in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-16-2006, 02:10 PM

Tags for this Thread

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