Here is my problem: I have 4 charts looking at values from a pivot table which do not refresh data when I filter the pivot table. The thing is: these charts I inserted manually selecting different …

I have a 2013 Excel spreadsheet that when I save it online and then download it, it claims to have external connections. It keeps trying to reference its old location for the pivot tables/pivot …

Apr 23, 2019 · I have an excel workbook which I have connected to a SharePoint 2016 On-Prem list via OData Feed where I have created some pivot tables based on the data it returns. I, …

Dec 30, 2018 · I rebuilt the model in the end, but as soon as I move the worksheets from the old file which I couldn't upgrade to Excel 2016, I get the message in the rebuilt file " This workbook …

It's pretty awesome how you can define Extract Transform and Load processes within Power Query without having to type in a single line of code. However how do I reference a Power …

Note: Someone at the Excel community board recommended asking this here. My question is similar in spirit to this one, but I'm not working on a pivot table. It's a primary table generated …

This works good, as long the Excel source file is located in the sam elocation as the new Word document is. Once we refresh the Word links it retrieves the data from the Excel in the same …

When I reopen the workbook and add x and y value and a new label (where I left empty cells to do so) that data point 'icon' comes on to the graph, but the datalabeldoesn't automatically …

These office documents are getting opened in the browser using Office Web Application including Excel Workbooks Recently, we installed and configured PowerPivot for SharePoint for …

Here is what I want to accomplish, I need information on the folder rights (Accesstostring will only put all the right in a string, I need them to be separted individually) folder count and file count …