+ Reply to Thread
Results 1 to 2 of 2

Quarters/Years UI Change Breaking Macros

  1. #1
    Registered User
    Join Date
    05-10-2013
    Location
    notts
    MS-Off Ver
    365
    Posts
    24

    Quarters/Years UI Change Breaking Macros

    Hi all,

    Bit of a head scratcher for me here. I have a few macros that build reports by building pivot tables. I ran one of these fine yesterday, but today my macros are failing because the way the pivot displays Years/Quarters with the field name now tagged on to the title, which is also pulling through to the macro side of things and causing it to fail:

    I expect:

    2.PNG

    But I am now getting:

    1.PNG


    This only seems to affect me - other uses are able to run my macros successfully still.

    Any ideas why this has changed for just me overnight?

  2. #2
    Registered User
    Join Date
    02-29-2024
    Location
    EGYPT - Cairo
    MS-Off Ver
    MS365
    Posts
    88

    Re: Quarters/Years UI Change Breaking Macros

    This is because Closed Date is a date column, and Excel generates Months, Quarters, and Years columns for any date filed automatically.
    Does unchecking it solve the issue, or do you want to do not being generated initially?
    Does Closeddate used to be a date column previously or it is a new setting?
    Try to test if you set it to General, will it generate these fields or not?
    Thank,
    Mohamed GadAllah

+ 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. Dates into years and quarters
    By andyh1905 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-26-2021, 03:22 PM
  2. Graphing using Quarters/Years
    By athomason in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-13-2020, 03:34 PM
  3. Months to quarters to years
    By miumamou in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-08-2019, 09:03 AM
  4. Calculating Rolling Sum based on quarters & years
    By Stathissp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2018, 10:53 AM
  5. Auto Populate quarters by just typing in the number of years
    By sugar_lips in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2014, 09:31 AM
  6. [SOLVED] Excel 2010 - Time between dates in years and quarters (.25)
    By undergrads in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-18-2013, 02:16 AM
  7. Show quarters and years on x axis of a chart
    By Kacee in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-19-2005, 12:06 AM

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