linked tables

Hello Mr. Excel Friends, I have a few sheets linked to a master data sheet via power query. I had added some columns to the master sheet, but when I refresh the queries on the other sheets they do not update to include the new set (for example there was a table that initially had 23 columns...

hello, I'm trying to find a way to pull worksheets from different workbooks and combine them into one master worksheet. The ranges are dynamic so they will be updated ever hour or so I'd like to have a macro that, when ran, combines them into one worksheet. The workbooks are always open on...

Hi, I've inherited an Access app that allows users to run a custom query using a form. It -has more than one linked table from SQL Server -Runs Access Sql on the tables before presenting The problem is that the tables were relatively small when they were made by my predecessors. Now they are...

I have thousands of rows of data and near 100 workers. I need dynamic dashboards like the one below with subtotals for each item category. I've accomplished linking Power Pivot to the SQL Database and creating a linked table in Excel. What is the best way to create dashboards that will...

Hi everyone, This is my first time here and I'm a self-admitted newbie at Excel. I think this might be a simple problem but I really, really, really don't know how to proceed. Any help would be great. Honestly. I'm using Microsoft Excel 2010. Now in my Sheet 1, I have created a Table with data...

I have an Excel application that uses ADO to query an Access database with linked tables from numerous other Access databases. I've noticed the speed of the queries has slowed down with the number of records increasing each day. This has prompted me to explore optimization ideas where I came...

Dear all, I am using Win7 32bit, Excel 2013. I have to work with excel-based data and need to create calculations that go beyond the limitations of excel which made me work with SAS in the past. With the new PowerPivot functionalities I am actually able to get my work done completely in Excel...

Hi All, I have a linked table in many excel files that pulls in a data range from a master file via a connection string shown below. Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Users\Files\Content.MSO\DD83F92E.xlsm;Mode=Share Deny Write;Extended Properties="HDR=YES;";Jet...

Hello all, I need to copy a linked table as a local table in Access 2000. Yes, Access *2000*. Please don't respond with "Why are you doing all the work of converting linked tables? Just use..." or similar, the answer is it's what I've been instructed to do by my manager and that's how he wants...

I have a general question. Suppose you link SQL Server tables in an MS Access Database. If you write a query from another application (like Excel) to the MS Access database, how much slower would that query be vs. the same query directly to the table(s) on the SQL Server?

Hi I have a table in Access linked to 3 separate Excel sheets. They contain user forms which update the records in the table with information input into the form. Within the userform code, I'd like to do 2 things: 1. Update the records in the datatable with the user form info 2. Refresh the...

I've seen other threads regarding similar questions, but not specifically to the approach I'm attempting to take. I have one workbook with 15 sheets, the first 14 are three column lists of up to 200 entries. I'd like to make the last sheet a dynamic list of all of the 14 previous sheets, so...