link

  1. K

    Link wont break

    Hello I have a workbook with a link to and old file, i have tried to break the link, open source, change link, get rid of any conditional formatting, delete irrelevant work sheets, data validation etc, but i still cannot break this link! Does anyone know anything else i can try? Thanks
  2. S

    Link between two sheets where filter doesn't mess up the link

    Hi. I'm trying to link between two sheets. There are filters on both sheets. Sheet1 A1 has the data: Cheetah Sheet2 A1 is linked to Sheet1 A1 using the formula 'Sheet1'!A1 This works well until I use the filter to sort Sheet1. Then, the value on Sheet2 A1 now shows the data on Sheet1 A1...
  3. Q

    Hyperlink function from drop down menu data validation list throughout entire workbook

    Hello need a little help "YouTube": Hyperlink function from drop down menu data validation list throughout entire workbook "YouTube": https://www.youtube.com/watch?v=3vRkA_7x9t8&t=50s The validation link hyperlink listed above works great but it links to other sheets and I need it to link on...
  4. Sharid

    Help on this bit of code

    I found this bit of code and would like to use it with some changes, currently it is not working for me, possible because it is set for FIREFOX and not IE. I am having trouble changing this as I am limited in VBA This might be the issue Original link to code...
  5. Y

    Return a google drive share link from the google drive folder in VBA

    I'm looking for a way to create a macro which will go to my local google drive folder and the folder name (let's say in cell A1), make it shareable to anyone (manually it's mouse right click >> Google Drive >> Share >> Get shareable link) and write in cell A2 that shareable link
  6. N

    how do I hyperlink to a named range in another workbook?

    how do i hyper link to a named range in another work book? i have: ='4. multi excel 4.xlsm'!totalnegative but it doesnt work
  7. W

    Pivot Table Data Source

    Hi I have an external data source in excel which I need a pivot table on, the data is growing and Im looking for a way of automatically changing (Expanding) the data source. The data comes from a web query and I am able to get the link from a right click on the data, but I cannot use this link...
  8. M

    Button with link url based on cell

    Hello. I am trying to figure out a way to have a single button send the user to google based on the content of a cell. For example. If F1 has JANE DOE... then once the button is pushed it would send the user to google and JANE DOE would already be in the search. I would think a simple google...
  9. F

    formula help

    Hi Guys i have some data i get with two basic columns part number and image link, i need to import these into my site with the first column being the part number and the image link, then the next image link here is one image link ( i did this ) <colgroup><col><col></colgroup><tbody> sku pic...
  10. N

    Can't change size of "picture link" when I copy the new sheet

    Hi Everyone, I have used "picture link" to paste the data(in sheet2) from my worksheet(sheet1) And I resize that picture to bigger. After that I copy sheet2 to sheet3, sheet4 and sheet5. The picture'size (from "picture link") is equal size of worksheet(sheet1) How can I resize "picture...
  11. A

    How to link a value in excel workbook cell which is on Google Drive to Another workbook in google drive

    Hello there, Hopefully everybody is fine, I have planned a lot and structured the data for many hours and days, now I would like to know how I can link excel cell value of workbook1 to workbook2 in the case that they are in google drive because when I opened the other workbook is shows a...
  12. MFish

    Photos in Excel linked to a folder using VBA

    Hi, I'd like to know two things... One: Is there a way I can add something in a userform (button, textbox, etc.) where I can upload a picture from a shared folder? Once you hit submit to transpose the information on the sheet it will show either the picture or a link to open up that photo...
  13. B

    Outlook VBA Change/Replace Hyperlinks Before Sending

    Hello, I don't normally venture in to Outlook programming, but I have a problem I'm trying to solve. My organization recently enabled ATP for incoming outlook email links from external sources. So now, when I reply to an email, or forward it internally, identifying information remains in place...
  14. H

    Break All External Links only on specific sheet

    Hi, i have this code that i've been tinkering around with - i'm trying to have it work so that it removes all external links only on a specific tab (Summary Tab). Am i headed in the right direction with this?
  15. A

    Link ppt to excel

    I have data on a sheet that has columns named Product code, product name, image1, image 2 and I need a code for ppt so that I can choose any product and it's related columns directly from ppt slide
  16. R

    Mirroring workbook

    Hello, I am having an issue that I can't seem to find a solutionto. I have 2 separate excelworkbooks. The main workbook containsseveral worksheets that are all linked to one worksheet (WIZARD). That worksheet is then linked to a user form(COMPANY SAT REQUEST). On one workbook Ihave it to...
  17. D

    Structure chart with Userform - Link little connectors by a larger and single connector

    Hi all, I'm trying to find the lines of code that would allow me to connect the little connectors of the row 5 to a larger one Here is how works the userform I've created The commandbutton1 allows to put the elements of the textboxes 1, 2 and 3 in the listbox 1 and 2. You can add as many...
  18. S

    Data Link Issue

    HI all I have setup vba code to get comments from another workbook. It works fine until I close down all workbooks and reopen. Then then link has changed from =GetComments('[EPN - SPN - ROTA 1st April 2019 to 1st April 2020.xlsx]Rota 2019-20'!J35) to =GetComments('\\Ukpnforfs01\1$\Power...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top