links

Evening All. I seek your help in what at first was a simple copy of formulas but has turned into a gigantic time consumer. I have a range A2:CV250 on Sheet1 that gets populated via a form input, (sales of products in 2 week cycles) I need to HAVE A FORMULA that links Sheet1!A2:C2 to...

I have an excel with multiple links (same domain, several webpages). Each link is a webpage with a database with the same structure. I want to download the content of the links into one wepage. Please advice. Thank you in advance.

Hi I have hundreds of links to other sheets in the same workbook and I'm looking for a quick way of identifying broken links without me having to click on every single one. I've searched the forum and I'm only able to find code for checking external hyperlinks. Hope you can help? Thank you!

Hello, I have two 2010 Excel workbooks: Book 1 is on a shared drive and linked to multiple other Excel books within the same folder. It automatically updates when opened without a prompt to update. Book 2 is on my local drive linked to a password protected (modify, not open) Excel book...

I know everyone is going to think this is an easy one to solve, but please read all before commenting. This is not the typical situation where all you need to do is CTRL F and search for [ or search for .xlm I've tried those fixes. It is not as simple as going into Excel Options and...

I have the following code that is used to import sheets from a different workbook into my active workbook. The code works fine but when a sheet gets imported there is a link that get created (usually because of some sort of conditional format applied to the imported sheet). I need to be able to...

Hi all, I have an Excel file, let's call it Month End, that has lots of external links to other Excel files. Thing is, when I open an Excel file (not one that is link to Month End), certain links don't show the correct value anymore, I have to reopen the source file so that the correct value...

Hello All, I am having trouble with passwords hoping its a simple fix. I have four sales teams of 5 people who each have their own commission sheet which are password protected to open. The team leads sheet has links to cells in each of his team. So when the team lead opens their file it is...

Hi, I have developed an Excel Add-In. The add-in is stored in C:\OneDrive\XJ15 Macros\Live\Freelensia Macros.xlam Note that the OneDrive folder has been moved to C Drive and the add-in is stored there instead of in the Personal Add-Ins folder. I have Excel connected to this add-in via Options...

Hello folks, I have a number of workbooks that are shared and this works well. However, some of these workbooks contain data links and I would like to know if it is possible to write a macro and assign it to a command button so that each user, on opening the workbook can click on the button an...

I have Excel 2016. Occasionally I have a difficult time breaking external links. My process is as follows: Data - Edit Link - Break link. If link is not broken then I delete any "named" ranges referencing an external files, and then Data - Edit Link - Break link again. Most of the time this...

Hi all! I am being asked by a co-worker if this can be done. She wants to create a file that will contain links to workbooks in 3 separate files. One main file with active links to several workbooks in 3 others. I've done research and currently use ASAP Utilities but I am not finding anything...

"We can't update some of the links in your workbook right now....." VBA code to ensure that upon opening the spreadsheet this automatically selects "continue" to this message? Any ideas please?

I open a workbook that has links to another workbook and do not update the links when prompted I have a macro to copies the data to another row. I need a macro that will update all the links after the macro has run Your assistance is most appreciated

Hello, I need help with a VBA code to update links in excel. Id like it to update every 5 min. The links will be between 2 different excel workbooks. Any help will be appreciated

Hello When I copy a sheet to a new book, the cells contain links to other sheets. Can I replace the links with the actual data easily and retaining the format? Thanks!

I have no problem creating hyperlinks in Drop Downs. I have numerous links and I want to change “Text to display”, since the links can be quite long. I tried the standard right click then clicked on Hyperlink, but when I change it on my list and I have a validation list, the link no longer...

I have an Excel file that is looking at a few hundred external Excel files. These external links now need to be changed to new files each of which has a new file path and name. I have a list of all the old files paths and names in column A of a spreadsheet and a list of all the new files paths...

Hi all, I am working on changes to a number of forms for a production database. In order to implement the updates, I made the changes to a development copy, deleted all tables, and imported all the tables from production. This seemed to work fine and I had the "new database" up and running...

I'm using this to loop through a range of cells and grab their values for use later: For Each Cell In Sheet11.Range("J2:J20")If Cell.Value = "YES" Then Links = Cell.Offset(0, -8).Value & " " & Cell.Offset(0, -7).Value & vbNewLine & Links End If Next At the moment it starts at the bottom and...