external source

Imagine I have my original workbook called 001.xlsx, in cell A1 I have the below formula already saved: ='C:\Users\mbxyz\File_001\[001.csv]Sheet1'!A1 This formula is returning the value from that specific cell, from that new workbook, from that folder. Now I need the 001 to be a dynamic...

I use Power Query to massage data from a number of sources. It works great. There are cases where to create the right analysis that I use pivot tables. When I create the pivot table, I select External sources and select the appropriate Query as input. Everything so far works great. The issue...

Hi everyone. I have a work book with 23 sheets with basic IF, SEARCH, ISNUMBER, SUM, AVERAGE and IFERROR formulae and data validation, all in the same workbook. I have not linked any cell or formula to a external source. But every time I open the workbook I get a pop up "This workbook contains...

Hey, so I have a userform which is supposed to update based off of another sheet. The user is given 5 options that update, however only 1,3,4 work while 2,5 do not. I double checked (more like 10x) the file and even copied down the lines that work into where 2 and 5 are located, but no matter...