+ Reply to Thread
Results 1 to 7 of 7

Unable to set the NumberFormat property of the PivotField Class

  1. 12-09-2022, 09:07 AM #1
    inspector-71
    inspector-71 is offline
    Registered User
    Join Date
    06-11-2009
    Location
    manchester, england
    MS-Off Ver
    Excel 365
    Posts
    37

    Unable to set the NumberFormat property of the PivotField Class

    Can anyone help on why I am getting this error

    Please Login or Register  to view this content.
    Thanks
    Reply With QuoteRegister To Reply
  2. 12-09-2022, 09:56 AM #2
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,332

    Re: Unable to set the NumberFormat property of the PivotField Class

    Can you manually set a number format for that field in the field options?
    Everyone who confuses correlation and causation ends up dead.
    Reply With QuoteRegister To Reply
  3. 12-12-2022, 03:57 AM #3
    inspector-71
    inspector-71 is offline
    Registered User
    Join Date
    06-11-2009
    Location
    manchester, england
    MS-Off Ver
    Excel 365
    Posts
    37

    Re: Unable to set the NumberFormat property of the PivotField Class

    Yes. It works fine manually formatting
    Reply With QuoteRegister To Reply
  4. 12-12-2022, 04:01 AM #4
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,332

    Re: Unable to set the NumberFormat property of the PivotField Class

    Using the field settings dialog, not the format cells one?
    Reply With QuoteRegister To Reply
  5. 12-12-2022, 04:10 AM #5
    inspector-71
    inspector-71 is offline
    Registered User
    Join Date
    06-11-2009
    Location
    manchester, england
    MS-Off Ver
    Excel 365
    Posts
    37

    Re: Unable to set the NumberFormat property of the PivotField Class

    I don't see any format options there, just subtotals & filters and layout & print
    Reply With QuoteRegister To Reply
  6. 12-12-2022, 08:25 AM #6
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,332

    Re: Unable to set the NumberFormat property of the PivotField Class

    That would explain why you can't do it in code then - the field is not being seen as numeric.
    Reply With QuoteRegister To Reply
  7. 12-13-2022, 04:22 AM #7
    inspector-71
    inspector-71 is offline
    Registered User
    Join Date
    06-11-2009
    Location
    manchester, england
    MS-Off Ver
    Excel 365
    Posts
    37

    Re: Unable to set the NumberFormat property of the PivotField Class

    Thanks for your help. Saved me going round the bend
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unable to set the CurrebtPage property of the PivotField class
    By MattEd82 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2016, 08:02 AM
  2. error msg : unable to get the PivotItems property of the PivotField class
    By Kim75 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-12-2015, 03:56 PM
  3. Unable to set orientation property of pivotfield class
    By williams485 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2012, 12:51 PM
  4. Unable to set the currentpage property of the pivotfield class
    By adoepker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-09-2011, 06:23 PM
  5. Unable to set the CurrentPage Property of the PivotField Class
    By Murali6688 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2011, 12:16 PM
  6. Unable to set the CurrentPage Property of the PivotField Class
    By SDruley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2011, 01:39 PM
  7. Unable to get the PivotItems Property of the PivotField Class
    By vinay_bagare in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2007, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1