connected

Hi, This might be a bit complicated to explain but I will do my best. I created a tool to forecast what is needed to buy each month (U14:U25) based on Part # in cell B2. In short, every time I type a new Part # in cell B2, it automatically gives me my desired data (taken from other sheets) in...

Hi, I'm having a strange problem where I can no longer connect to salesforce via GetData as "We don't support this browser". I am running IE 11, updated everything from Chrome & Edge. Used to work fine before but has stopped working since working from home. VPN is on (not sure this matters)...

Hi all, Using Office 365. Is there a way to update the Data Source for all of my Pivot Tables that are connected to 9 Slicers? When I try to update the first Pivot Table, I receive a warning message How can I update all Pivot Tables at the same time to defeat the warning? Thanks, -Lou

Hello! I have a workbook with connections to 4 seaparate workbooks. All of a sudden when I open the main workbook, it opens all of the files connected to it. This did not happen before. How could I stop Excel from doing this, while refreshing the connections as it used to? Cheers

If I have a list of job titles [JBTBL], and a list of contract years [POPTBL]; I need to copy the list of job titles for as many times as I have years, lets call this the DetailTable. Then if I change/delete/add a job title from the job title table or add or delete a contract year from the...

Good afternoon everyone, i have two excel workbooks one is an input and the other is a display sheets (its on a screen always on) these two workbooks are always connected via get data from workbook. the "display workbook" receives the information into Sheet2 like so (see image) i want to...

Hi there, I have been using the get and transform function in excel for a while. I have a workbook with a lot of individual reports. I have connected them using get and transform, but when I replaced the data with current month's data, for some reason my merged table that is connected to all...

Hello everyone! I am a beginnerin using Excel and have the folowng question. I havea dynamic row. I want to enter a formula into the cell which will connect it to the other cell with the year. For example, what to do if I want to make the cell change its value in case the connected cell is...

Hi All, Could someone help me with the below please. I've googled as much as I can but everything I try gives me error messages. I need my code to check if its connected to a certain network drive, if it is it will then save, it is isn't it will do something else I am testing it on an...

Hi All, I have been working on a workbook which contains around 150 worksheets to store monthly project reports. These are compiled using a number of UserForms and Dashboard entries. After making some additions (about 12 sheets) and some vba code changes I saved the file / wb and the file went...

Hi and thanks in advance If I use: Dim wActPrinter As String: wActPrinter = Application.ActivePrinter If wActPrinter ="" Then 'I can request to install one, no problem But If wActPrinter <>"" and is not connected, because for eg I am using a laptop in a Taxi and I do not have the...

Hi! I tried to use the sync slicers guide (https://www.mrexcel.com/news/sync-slicers-in-excel/) but it's not working for me. This is the code I have: Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) Dim sc1 As SlicerCache Dim sc2 As SlicerCache Dim SI1 As...

Hello. Very new to VBA (very new). I have a spreadsheet with three columns and need to do some work in the last two columns. [Sheet 1].[Column A] - ID [Sheet 1].[Column B] - BUILDING [Sheet 1].[Column C] - DESC <tbody> ID BUILDING DESC A L1 L2 Very Large Extended B L1 L3 L4...

Hi, I am looking for a way of checking or detecting whether the user is currently connected via RDP / MSTSC. I think I'm half-way there as I can use the ENVIRON$("SESSIONNAME") variable to get either "CONSOLE" or "RDP*". If that variable is "RDP*" then this gives me half of what I need...

Hi Im looking for some simple code that copies the value is G9 to AK9. The spreadsheet i am working with keeps refreshing as it is connected to an application so i want the value to keep refreshing automatically also. Kind regards.

I have a connected database that I want to be able to create a selection box on, which once filled out I can click on a button and update my connected SQL Query. This is the query and it is fairly simple. I want to be able to change the item in the where statement. Anyone ever do this? I have...