If the Excel workbook is static then you won't see any changes. Because the data isn't changing there is no reason to perform a refresh on it. So I'm not sure what's meant by "...not seeing any success."
No success means the whole workbook is failing to refresh because of the excel file attached. If I remove the excel sheet it refreshes just fine. The workbook is using custom SQL also. I think the published workbook is still trying to connect to the excel sheet on my hard drive. How do I tell it to connect to the excel file I published to the server?
Open the workbook in Desktop, connect to the new published data source on Server, replace your Excel data source with the Server data source, resolve any errors, close the Excel connection, save, then re-publish the workbook to Server.
1 of 1 people found this helpful
An alternative is to "Include External Files" when you publish the workbook so the Excel file gets included, no need to publish it to Server. But if you're using an extract of the Excel file (for performance or functionality) this won't work because all extracts in a single workbook must get refreshed on the same schedule or not at all.
The third option is to relocate your Excel file to a network location that both Desktop and Server can access, change the existing connection to the new path, then you can either use an extract or not, because Server will be able to find the Excel file on the network.
We regularly use all three of these options with our Excel data depending on whether it needs to be updated and by whom.