-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
open workbook links
-
O
Vlookups not working unless external source workbook is open
Help please! I have a workbook that is vlooking up to another workbook. The issue is that when I open up the WB that has the vlookups, it gives me the update links dialog box (which is fine). When I click update, I then get an error box that it cannot update the links and #refs everything...- oosorio
- Thread
- linked workbooks open workbook links source file vlookup
- Replies: 1
- Forum: Excel Questions
-
B
Update links when opening workbook without opening source file
I am using the code below to open a workbook... Sub OpenGPK() Workbooks.Open Filename:="\\lon0306\dfs\data\dta\sim_spf\charities team\applications\Gourmet Performance Kitchen.xls" End Sub However whilst opening this workbook I would also like to update links to from workbook without opening...- BigDelGooner
- Thread
- open workbook links
- Replies: 4
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Payment term and Cash flow (formula linked with costs)
- Started by Adfinance
- Replies: 43
Hi everyone, I need to calculate automatically the cash position (cashout) based on payment terms and costs. The payment terms may change, so I... -
Match to a list with wildcards
- Started by The Gent
- Replies: 29
Good day all, I am trying to do something which it my head feels quite simple but I can't get a result. I have four dimensions in a spreadsheet... -
Inserting text above first blank row then above third blank row etc.
- Started by Livin404
- Replies: 24
Greetings, I have a VBA where I'm trying to insert text into blank cells. On worksheet "Deficiencies" I have seven groups of ranges that I... -
code to get students marks from source sheet to destination sheet.
- Started by rzml
- Replies: 22
hi, I am looking for a VBA code that can get student marks using his ID and evaluation type (as headers) from source sheet to destination sheet. I... -
Run VBA on all open tabs
- Started by Dannottheman
- Replies: 22
Hi, I searched but could not find an answer to this. How can I make the 3 VBAs below run on all the open sheets/tabs in my Excel? Right now I... -
Functions to separate a string separated by commas
- Started by jeffdolton
- Replies: 22
Hi, I’ve opened up another thread as my request this time is a little different. With help from experts on this forum, and using some basic excel...