Reply to thread

Message: [QUOTE="Jeff Overton, post: 2668392"] I am experiencing similar symptoms, which occur when adding a workbook connection to an Excel file of any of the following formats: .xlsb, .xlsm, or ..xlsx. I receive the same message as described in this thread. I am using Excel 2007 (12.0.6331.5000 SP1 MSO 12.0.633.5000) and using the Microsoft Office 12.0 Access Database Engine OLE DB Provider. I am able to successfully establish a workbook connection to Excel files of format .xls. However, I cannot successfully use this data because it hangs when defining a pivotable that uses this connection ( connection is to a table defined as $a$7:$y$39252). So i thought I could avoid this by saving as ..xlsb. However, I cannot successfully establish a connection to the other file when it is any any other format. I tried .XLSX, .XLSB and .XLSM. [/QUOTE]