Hi all -
Trying to work through tutorial on creating offline cube from an Excel file, A CompleteGuide to PivotTables: A Visual Approach, Cornell, ISBN 1-59059-432-0, pg 248.
Steps I am taking:
1. Click on Data Menu
2. Import External Data
3. New Database Query
On Databases tab
4. Click on Excel Files*
5. Click on Browse Button
I migrate to the loction of the sample files I downloaded, but no files appear in the Browse Data Sources dialog window.
Files of type drop down reveals only "Data Sources" (w/o quotes)
I browsed the folder with Windows Explorer. There are several Excel files in the folder as well as sample, .cub and .mdb files.
I do have Excel 2007 installed on the PC as well, but working through the tutroail with Excel 2003.
Any ideas why the Excel files are not visible?