Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2015, 09:34 AM
Ken Barr Ken Barr is offline Excel's 2010 Data Warehouse tab disappeared on 2013? Windows 10 Excel's 2010 Data Warehouse tab disappeared on 2013? Office 2016
Novice
Excel's 2010 Data Warehouse tab disappeared on 2013?
 
Join Date: Dec 2015
Posts: 3
Ken Barr is on a distinguished road
Default Excel's 2010 Data Warehouse tab disappeared on 2013?




I've switch from Office 2010 to Office 2016 (360 subscriber) and surprisingly have found the unique Warehouse tab is missing. Then I've asked to go back to Office 2013 and still to no avail. Checked out a YouTube video and saw Office 2013 DOES have the Warehouse tab.
What's going on?
Anybody has a clue?
Reply With Quote
  #2  
Old 12-08-2015, 09:58 AM
Kevin@Radstock Kevin@Radstock is offline Excel's 2010 Data Warehouse tab disappeared on 2013? Windows 10 Excel's 2010 Data Warehouse tab disappeared on 2013? Office 2016
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Whats the Warehouse Tab!
Reply With Quote
  #3  
Old 12-08-2015, 10:34 AM
Ken Barr Ken Barr is offline Excel's 2010 Data Warehouse tab disappeared on 2013? Windows 10 Excel's 2010 Data Warehouse tab disappeared on 2013? Office 2016
Novice
Excel's 2010 Data Warehouse tab disappeared on 2013?
 
Join Date: Dec 2015
Posts: 3
Ken Barr is on a distinguished road
Default Here is a DW Tab example

This snipped one was taken from Youtube.
(
Video Name: Basic Excel Business Analytics #31: Power Query: Import Multiple Excel Files with 1 Sheet Each
Video URL: https://www.youtube.com/watch?v=XPLVkLSagIY
Time: 10:17

)


file:///C:/Users/mrspi/Desktop/_TEMP/Capture.PNG

As you can see, the Tabs goes like this:
File, Home, Insert, ...., PowerPivot (11ht item).
How do I get that?
Reply With Quote
  #4  
Old 12-08-2015, 10:36 AM
Ken Barr Ken Barr is offline Excel's 2010 Data Warehouse tab disappeared on 2013? Windows 10 Excel's 2010 Data Warehouse tab disappeared on 2013? Office 2016
Novice
Excel's 2010 Data Warehouse tab disappeared on 2013?
 
Join Date: Dec 2015
Posts: 3
Ken Barr is on a distinguished road
Default

https://www.youtube.com/watch?v=XPLVkLSagIY
Time: 10:17
11th Tab (POWERPIVOT)
Reply With Quote
  #5  
Old 12-09-2015, 03:10 AM
Debaser's Avatar
Debaser Debaser is offline Excel's 2010 Data Warehouse tab disappeared on 2013? Windows 7 64bit Excel's 2010 Data Warehouse tab disappeared on 2013? Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

If you have a version of 2016/2013 which includes Power Pivot, you need to enable it in the COM add-ins dialog.
Reply With Quote
Reply

Tags
excel bi, warehouse

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel's 2010 Data Warehouse tab disappeared on 2013? Excel 2013 Graphs automatically aligning data labels to end of bar katm3 Excel 7 08-06-2015 04:36 PM
Excel's 2010 Data Warehouse tab disappeared on 2013? Word 2013: My custom table styles disappeared from Gallery sinz54 Word Tables 1 03-13-2015 05:02 PM
Charts - formatting dates in a data table - Excel 2013 IanGUK1 Excel 0 12-04-2014 01:44 AM
merging data sets in excel 2013 nwiabrad Excel 9 07-24-2014 12:07 AM
Excel's 2010 Data Warehouse tab disappeared on 2013? saving data in excel 2010 from excel 2003 johnkcalg Excel 1 02-06-2012 07:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft