Unable to Refresh Powerpivot when data is modified

Kaitlin29

New Member
Joined
Feb 5, 2016
Messages
1
Hi,

I've linked a data set in one workbook (multiple tabs with identical columns) to a powerpivot in another workbook using a modified SQL in the table properties 'query editor'. The powerpivot loaded all 12 tabs from the data set without an issue.

However, when I change the data in the data set, ex. a 5 to a 1, when I click refresh in my powerpivot, it gives me an error message: 'We couldn't refresh the table '___' from connection '____'. OLE DB or ODBC error: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.'

I'm wondering how to resolve this? What I could be doing wrong? Please help!
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Matt Allington

MrExcel MVP
Joined
Dec 18, 2014
Messages
1,265
How about trying Power Query instead. I didn't even know you could use SQL to import from a spreadsheet, but Power Query is fabulous and well worth a look
 

Forum statistics

Threads
1,144,369
Messages
5,723,950
Members
422,527
Latest member
TotalBeginner201

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top