locked
How to 'Mark as Date Table' in PowerPivot using menus RRS feed

  • Question

  • Hi All,

    Working in PowerPivot for Excel 2010 running on an older operating system which does not support the ribbons. I cannot find any way to mark a table as being a date table in this interface.

    I have found the TechNet page (http://technet.microsoft.com/en-us/library/gg399147.aspx) that shows how functions map between the two interfaces but there is no mention here on this important functionality, can anyone help?

    Thanks

    John

    Tuesday, November 6, 2012 11:30 AM

Answers

  • Hi John,

            Here is a screenshot from an XP machine. XP and 2003 would both have the non-ribbon menu. Hope this helps. If you don't have a column of type Date, you won't see it as enabled though.

    Thanks,

    Bradley

    Mark as Date in XP Menu.

    • Marked as answer by John ST Friday, November 9, 2012 7:03 AM
    Friday, November 9, 2012 3:47 AM

All replies

  • Hi John,

    What's the version of your PowerPivot? This is a new feature in SQL Server 2012 PowerPivot for Excel. Here are some articles for your reference, please see:
    What's New in PowerPivot: http://technet.microsoft.com/en-us/library/hh272053.aspx
    Mark as Date Table Dialog Box: http://technet.microsoft.com/en-us/library/hh272061.aspx

    Regards,


    Bin Long

    TechNet Community Support

    Wednesday, November 7, 2012 10:17 AM
  • Morning Bin,

    Thanks for the links; I know how to mark a table as a date table and then to leverage the time aware functionality, that is not my question.

    I am unsure how to find the version that I am using, the help does not have an 'About' option.

    I am able to Mark tables as being date tables on the instance installed on my local machine (running Excel 2010 on Windows 7 64 bit). We are providing users access to PP via a Citrix environment with Office 2010 installed on a Citrix desktop which has Windows Server 2003 R2 Enterprise SP 2. I am able to copy the developed models to this location with tables marked as being date tables and the time aware functions work.

    We are trying to encourage power users to extend and develop their own models but the install on the 2003 box does not have a ribbon and I cannot find any way to mark a table as a date table using the menu interface.

    Can you please advise how I should do this, or is it a bug that needs to be reported back to the dev team?

    Thanks

    John

    Thursday, November 8, 2012 7:42 AM
  • Hi John,

    Sorry for my misunderstanding.

    You can refer to the following steps to check the PowerPivot for Excel version:

    1. Start Excel.
    2. Click PowerPivot tab, and then click "Settings".

    Please see the screenshot below:

    Here is an article for your reference, please see:
    How can I check what version of PowerPivot for Excel is installed on my machine: http://powerpivot-info.com/post/89-q-how-can-i-check-what-version-of-powerpivot-for-excel-is-installed-on-my-machine

    To be honest, I have never test SQL Server PowerPivot for Excel on Windows Server 2003. But I suggest you take a look at the system requirements in this link below:
    http://www.microsoft.com/en-in/download/details.aspx?id=29074

    Regards,


    Bin Long

    TechNet Community Support

    Thursday, November 8, 2012 7:54 AM
  • Hi Bin,

    Thanks for the quick reply,

    Both the versions I am running (local and Citrix) are 11.0.2100.60

    I have looked at the system requirements and Server 2003 is listed and we meet or exceed all the other minimum requirements. I have seen mention that when running under XP or Server 2003 the ribbon is not shown and you get a menu interface instead. While this is less than ideal we can live with the aesthetic limitation as long as we can access all the functionality. Given that everything works when the models are run on the 2003 box I am struggling to understand any reasoning behind not having an option to mark a table as 'date'.

    John

    Ref: MSDN Social thread on ribbon/menu

    http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/thread/8b4d919c-9d04-4431-bf74-a008aa01d147/

    • Edited by John ST Thursday, November 8, 2012 9:01 AM Added reference url
    Thursday, November 8, 2012 8:35 AM
  • Hi John,

            Here is a screenshot from an XP machine. XP and 2003 would both have the non-ribbon menu. Hope this helps. If you don't have a column of type Date, you won't see it as enabled though.

    Thanks,

    Bradley

    Mark as Date in XP Menu.

    • Marked as answer by John ST Friday, November 9, 2012 7:03 AM
    Friday, November 9, 2012 3:47 AM
  • Thankyou Bradley,

    That is exactly what I was looking for.

    John

    Friday, November 9, 2012 7:03 AM