refresh data

Hi All, Quick Question. I know that I can generate Random numbers with fixed numbers using Randbetween (001,999) If I have multiple Randbetween numbers on a sheet and want to 'keep' the numbers, how do I stop all of them refreshing / changing on opening and closing the sheet / pressing the...

I have created a dashboard from pivot tables of demo data on COVID-19. Initially the pivot tables were from solely created from one data sheet but later other pivot tables (and charts) needed data from a second sheet. Excel created a Data Model to do this (have pivot tables from different source...

Hi, I would love for some help in writing some VBA code such that it will scrape data from a given URL for betting sites, and will return the specific betting odd values as required within a sheet. I then want it so that these values can always be refreshed as required. For example: Using...

That title was quite the task to try to summarize. I have an ever increasing amount of API keys I can call upon of which each one, obviouslly, has some rate limitting set out on it. I am looking for a solution/ formula particularly, where I can pull an API key to utilize in my overal...

All, hoping someone can help. I have a table that needs refresh from other source based on column headers. Basically: "source" sheet will contain new data. there is a number of headers we dont use "target" sheet will have the headers (and data) we want to update looking for a way to: 1/ look...

Dear All, I have a huge problem with how to refresh only modified files or new files in folder? The situation is as follows: I have a folder where different peopel store the files (more than 1500, all files have the same structure) and when I import data using PQ it takes ages because it...

Hi Gurus, First, I'm fairly new to VBA but have realized it is the only way to accomplish what I'm trying to do and 100% willing to learn. What I have is a workbook with 3 different pivot tables. I'd like for a reference above each to say when that particular pivot table has been refreshed...

We have an excel file with data in it, and we are wanting to display a "Dashboard" at multiple shop computers to view real time progress deriving from one excel file. My angle was to create a shared dashboard file separate from the data. I would like to have the dashboard be real time results...

Hi All, I have a master spreadsheet, "District Summary" that has data from multiple schools. I have a column that has an A, B, C, etc. based on which school it is. I then broke it out into individual worksheets for each school. I did this by referencing the master sheet, then sorting based on...

Hello, I have been running a report weekly using the below code in a module to pull all of the excel invoices I need into a query. My issue is that every week I have to rerun the report from scratch because if I just click run it will re-pull the same files I already have in it again. Is there...

Hello, I am wondering if it possible to bypass the pop-up window prompting to select the text file when refreshing data imported from text file. I have a tab separated text file that gets updated by an external program. I find it annoying that I need to select the file every time I want to...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> GOAL: Linking SharePoint to Excel, so that Excel will contain pivots. Multiple SharePoint tables have been linked to individual sheets in Excel. A macro was written to...

I have a large metrics Excel 2013 workbook with a lot of hidden tabs with data links pulling data into tables. I have a handful of these set to refresh upon opening the file...which causes a warning upon opening the file to update links or not. Can this warning be turned off so the user...

Mr excel team and all users thank you for the support and abundant knowledge transfer. :) Any better ideas ? This is Workbook A (name keeps changing) I got a number 404 in P1. (total 404,504,604... 40 numbers) Once i change the number data is updated in all sheets. Then user click Ctlr+Q to...

Hi, I am trying to use VBA to automatically refresh a specific pivot table which is based on another table which the last based on another pivot table. All data resides in the same worksheet. Once the first pivot is being changed the table of course get updated but the pivot which is based on...

Greetings! I have an Excel 2010 workbook that includes a table linked to my SharePoint 2013 site by a data connection. The SharePoint list feeds the table standard information that's managed on the SharePoint site, but I need the user of the Excel workbook to be able to enter text manually in...

Hi, I have selected "centre across selection" to have text sit in the middle across several columns without merging cells. However when I press F9 to refresh, the text moves left and right depending on which cell I have selected when I hit F9. How can I make sure the text doesn't move and sit in...

Hello, Our organization has about fifty scorecards in Excel, with three data connections apiece. All of them refresh from the same password-protected database. Is there a way to write a script that will open and refresh all the workbooks at once, wihtout having to type the login and password...

Hi all, Is there any line item in VBA that we can add that will allow the macro to run and the file to update during times that the file is closed. For example, I would like to update some data every two weeks, however, do not wish to keep opening this file and manually refreshing it. Thanks...

Hi, I'm new to PowerPivot, and have the following question: I build a very basic powerpivot file, which combines raw data from two excel files connected by a shared key. Now I added more columns to one of the source file (it's an export from our CRM system, so these are completely new fields...