5 comments

• Levi Bailey commented  ·  October 25, 2015 11:08 AM  ·  Flag as inappropriateFlag as inappropriate  ·  Edit…  ·  Delete…

  Hi Ash

  I think you're talking about this view: https://support.content.office.net/en-us/media/98ab21eb-4042-4a2d-8f92-d345bbe5ca78.png

  Yes, this is largely a request of hosting that experience as a new sheet tab in Excel (so the "Sheets" collection would be able to include the existing Worksheet and Chart objects as well as something like new DatabaseSheet objects). There would be no need for an equivalent to the pane at the bottom of the image (where measures are defined). There would need to be an easy way for logic to flow between Worksheets and DatabaseSheets.

  I hope that makes sense? Happy to try again if not.

  Best, Levi

  Save Submitting...
• AdminAshvini Sharma (Lead Program Manager, Microsoft) (Admin, Office.com) commented  ·  October 25, 2015 10:45 AM  ·  Flag as inappropriateFlag as inappropriate  ·  Edit…  ·  Delete…

  Hi Levi,

  Thanks for the response. Since you're familiar with the Table viewer in Power Pivot, wondering how the functionality of the "database" sheet type would be different than that capability. I.e. is the request a matter of hosting that experience as a new sheet tab in Excel? Or would that still be too much?

  thanks
  ash

  Save Submitting...
• Levi Bailey commented  ·  October 25, 2015 10:36 AM  ·  Flag as inappropriateFlag as inappropriate  ·  Edit…  ·  Delete…

  Hi Ash

  I'm not Bill but I did create the original suggestion and have looked at the 'Data Model' and 'Power Pivot' capabilities of Excel 2013. These are fantastic features however they can be overwhelming to many Excel users, so even considering these existing tools I believe that a simpler "database" sheet type would be useful.

  Best, Levi

  Save Submitting...
• AdminAshvini Sharma (Lead Program Manager, Microsoft) (Admin, Office.com) commented  ·  October 25, 2015 10:30 AM  ·  Flag as inappropriateFlag as inappropriate  ·  Edit…  ·  Delete…

  Hi Bill,

  Have you looked at the 'Data Model' and Power Pivot capability of Excel 2013 and later? It's designed to scale to much larger datasets than the grid, and support joins, calculated columns & measures..

  Would love to hear of your experience with it

  thanks
  ash

  Save Submitting...
• Bill Bekenn commented  ·  July 11, 2015 9:09 AM  ·  Flag as inappropriateFlag as inappropriate  ·  Edit…  ·  Delete…

  I would like the normal sheet size to be reduced to something more manageable, but still bigger than 256 columns (Excel 2003). A "Database" sheet could then be much larger but should be restricted to having NO FORMULAS. I think that would potentially speed up calculation etc. as these large sheets would not need to be included in the calculation of formulas.

  Save Submitting...