link

Hello, There is a workbook links that is hidden in my Excel 2016 Excel file. I believe it is causing Excel to crash as it tries to access a network folder I don't have access to. The only way I know the links exist is through the Inquire tab, using the Workbook Analysis tool. The problem is...

Hi!!! I'm working on a data base where I need to link cells to another sheet, but its not working and i keep getting the "Cannot open the specified file" message. Even the simplest way using =HYPERLINK('Other sheet'!A509) When i use de manual option "Ctrl+K" it does work. But I need to link...

Hello, Is it possible to code VBA to link 2 to 3 sheets (template for Winshuttle). 1 button can run the 3 winshuttle scripts with 3 excel sheets template? Can you give me idea how will it be? Thanks

Hi i have few links in column A of an excel sheet. i am looking to check for java scripted links by opening each link manually on IE, then press CTRL +U it open up a page on browser then i have to find the same link of column A there if its present there column B is filled as Yes else No...

I have a cell in a worksheet which is linked to a cell in another workbook. In theory the link should update when I open the first workshheet, however the linking formula has changed itself to c:\Users\Michael\AppData\Roaming|Microsoft\Excel\file name and cell reference. It is supposed to link...

Hi I need a smiliar vbs but with Sub, not function which able to update the status on Col J when i activate the macro. It will left a remarks Directory & Link Ok File was not found in folder The best if can differentiate which one is Folder, which is link :) <tbody> H I J FOLDER Path...

Does anyone know how to link an csv file to an Access database? I can link xlsx or a text file, but not sure about csv. Thanks

My slicers are using different tabs for sources, so they won't link in the report connection. I once created a massive slicer that would edit any slicers you attached to it without using the report connection feature. Although, for the life of me, I cannot remember how I did this. Any...

Hello I am trying to construct a vba macro to count everytime a cell contains a hyperlink in range of data. Currenly having it search the row for a hyperlink and then if it finds a hyperlink it will count and not delete the row, deleting the row if it doesn't contain a row. I am currently having...

Hi I have a UserForm with option buttons combobox and textboxes at the moment it is used for booking in and I have added another option button to book out and I need it to deduct the value, see link below to see how it works. https://www.dropbox.com/s/m95u5skdxnjgj0x/TESTER1.xlsb?dl=0

I'm trying to automate as much as I can with our billing process. The one kink in the chain is getting everything to Quickbooks. Invoices have to be typed in manually which is ridiculous. I transfer them from Excel spreadsheets (link below) and into QB versions (link below). Is there any way...

Hello and thank you in advance for any help. I'm looking to have VLOOKUP return a hyperlink, but one which is a reference within the workbook, rather than a URL. Can't find a format for writing the hyperlink to begin with that Vlookup can then return as working. Explanation of the below...

I have a column of unique text values that are URLs (web addresses). I need to convert all of them to hyperlinks that point to the unique URL but want all of the rows to display the same text. My actual dataset is hundreds of rows. Data www.1234.com www.5678.com www.9101.com Desired output...

Hi, I have a userform with a combobox and textboxes and I need to minus a value from the userforn and deduct it from a database. please follow link for more details. https://www.dropbox.com/s/tknfwt064ungls2/Booking%20Out.docx?dl=0

I am trying to download data from data.cms.gov the file contains more than 1.2 million rows, used power query download web option but get error message all the time. Below is the link, I am using excel 2013. Can someone help me...

I have excel files A and B. File A is linked to File B. A acts like input & output file, but A needs to pull data from B during the update. I sent file A by email to a colleague without file B as B has confidential data in it, and I was expecting file A couldn't be updated without B. However...

I have built a report in Excel. The report includes a set of web links. I used the following formula to create a link and the link works perfectly in Excel. However, when I convert the Excel report to PDF, the link doesn't work. Any suggestions? =IF(OR(O204="Blind Spot", I204<4)...

In the past I recall I can easily link in File 1's range with data from File2's range. Now I found I can only import from File2 data using powerquery. Where can I use the old method to link from File2's range so it is dynamic meaning when data in File2's range is changed, File 1 can be updated...

I am having difficulty finding the best way to link cells from one sheet to another. I want to keep the rows together and only transfer info that has a blank recovery date. I have Columns B-L and 305 rows. In Column B, I have Dates of Service with other identifiable info in the columns to...

Hello and thank you in advance if you can help, I am using excel 2019 64 bit on a PC. I have a VBA macro that I have used to create hyperlinks in the past. It has always worked fine, and it "sort of" is working now, but it is not keeping the absolute hyperlink I need, so it will not open the...