This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
i just want to have a consolidated data from multiple excel workbook.. what i did was i created new excel workbook and add connection and select the workbook and its worksheet.. after that i select existing connection and select the connection that i added.. and it was successful when refreshing the connections.. but when i upload it on sharepoint online 2013 and use it on excel web access web part... when refreshing the connection i got this error..
A comprehensive suite of productivity tools and cloud services that enhance collaboration, communication, and efficiency. Combining classic Office apps with advanced Microsoft 365 features, it supports both personal and business needs
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
hi eddy,
thanks for your consistent patience. after doing more tests and research, i found that it’s not feasible to refresh data in a workbook like the one you created in a browser window. below is the detailed explanation:
first, i followed your steps and created a workbook similar to yours. i could refresh the data locally as you did. after uploading this workbook to a sharepoint library, i inserted it into a page in sharepoint site using excel web access web part as you did.
when i tried refreshing the data, i got the same error message:
after searching online, i’ve found this article: comparing excel services and excel web app (sharepoint 2013) and the information below in it:
so i went to sharepoint online and checked the url of the excel file i inserted in the excel web access web part:
seems excel web access web part uses the excel web app as the article mentions above and when power pivot refreshes data, it will use data model.
in this case, i’d like to invite you to submit this idea at our uservoice. many great feature came directly from our customers. your understanding is highly appreciated.
regards,
fraser
Hi Eddy,
Based on the error message, the problem seems to be related to the customization in this specific workbook. To confirm it, can you let us know if the problem occurs to a new created workbook with less customization? If the problem is related to the customization in the specific workbook, we suggest that you adjust this workbook based on the error message and check the outcome.
Regards,
Jerry
How sir? sorry Im new in sharepoint.. Thanks
Eddy have you tried creating the Excel sheets in SP instead of out of the environment?
My goal was to have graph using the data of multiple excel workbook that why I created a new workbook to consolidate the data.. I just got an error after I upload and use it on excel web access web part.