Forum

Indeed, this will not solve the last query refresh, and I know no way to capture that. The only functional solution is to add a wait time after the...

Hi Greg, You have 2 options to refresh a connection: with background refresh set to false or to true. Go to Data-Connections, select the connectio...

You have to bring the data from the external file into a new sheet, then point your offset formulas to this new sheet, instead of pointing to the exte...

You can use C:Temp, if you create that folder in that location, it does not exist. The system temp folder is in a different location. The image wil...

Hi Barry, Here is the code you can use to save the used range as an image, then attach the image in email body as a preview: Option Explicit Su...

Hi Hava, You have formulas in Forecast.xlsx file, in Orange sheet, range O2:O10. There formulas are pointing to cells from column P for the Height ...

Hi Barry, In the attachments section, there is a button to Add Files to the upload Queue, this will allow you to browse for a file. After you selec...

No, Excel will not tell you that a link was created when you copy a sheet to another book. You will get a warning only when there is a name conflict, ...

Hi Frans, There is no such thing as vba links. @TimC: Most probably, there is a defined name that points to another file, you have to edit th...

Hi Hava, Your formula is using empty cells for the height argument of the OFFSET function. An empty cell will mean zero cells height range, and tha...

Hi Martha, That sounds like a good task for Power Query and Power Pivot. Keep in mind that you don't have to bring all the data into an excel sheet...

Only if you have more files, if you have changes to the same files, a simple refresh will be enough. If you add new files every time, then you need...

It should be before the last round paranthesis: (it should end with 2 round paranthesis, 1 curly bracket, and another round paranthesis) Table.Fro...

Hi Will, Attached is a Power Query version to create the list of lists, instead of using formulas and pivot tables. The query is: let ...

Why would you use that? You have dedicated file and folder picker dialog: Sub ListFiles() Dim Fld as string With Application.FileDialog(msoFileDi...