workbook connections

I have 4 workbooks that each contain a table with identical structure. I have connected the first two in Power Pivot. In order to have them all connected do I merely connect #3 and $4 to each other or are they connected to either #1 or #2 workbook? The SQL statement for #1 and #2 is -...

A short explanation; I have a large amount of reports in one folder, and they are all formatted the exact same way every time, except for the date in the file name (ex. Out of Stock Report WE 04.20.16.xlsx). In the workbook where I have my formula, I'm referencing a cell that has a date in it...

Hi , I'm would like to use an existing workbook connection (based on an ODC file) and then change the command text from a SQL statement constructed in the spreadsheet. Getting the SQL is no problem but how do I call an existing workbook connection and then execute this with the new SQL...

On occasion, my percentages in my graphs(saved perfectly as percentages) will open as decimals for someone else? I have unlinked all sources attached and cannot figure out why this happens? Any input is appreciated.

Hi all, I've got one overview workbook & several individual workbooks. I want certain information to feed through to the overview book. I know how to do this but there's a few other bits I want to do.... I want four cells worth of information fed through from workbook #1 & the overview to...

Hi All, I am trying to change the absolute file path for my connected workbooks to relative, but I'm coming across errors and I'm not too sure how to resolve. My folder structure is as follows: Client (folder) -Master Report.xlsm (file) --Data (folder) ---dataset1.xlsm (file) ---dataset2.xlsm...

I'm not sure if this can be done, I've been looking into linking workbooks, connections, etc. Any help would be much appreciated. Here's what I want to happen: Several users complete an excel form (Form) where only certain cells are unlocked for them to enter data. One of these cells is a...

Hi, I'm looking for a way to display the "Last Refreshed" date and time in a cell. I know you just have to click "Data>Connections" to see this but as the workbook has lots of connections it would be really handy to see these in a cell on my variables sheet. Any ideas? Either VBA or somekind...

Hello to everyone, I wrote a code, which allows me to automatically import the Text (.txt) files (that are located in the same folder) on different worksheets (according to a certain criteria). But I have a problem with the duplication of data: I would like to import one text file only...