workbook link

  1. N

    Data Connections and Workbook Links

    I am creating links between 2 excel workbooks. When I open one workbook, there supposed to be a popup message as below for me to decide whether to update or don't update the links from the close workbook: In Trust Center, already checked "Prompt user about Data Connections" for Security...
  2. S

    Macro to link to another workbook

    Hi guys, I am fairly new to VBA but I'm hoping someone can help me. I will try to explain what I need the code to do. I am an accountant and my main file that I am working on has a list of properties with their respective market values in the adjacent column as an example. The total at the...
  3. 1

    Link to workbook using nominated cell text referencing

    Hello, I am wanting to link to a seperate workbook cell using the formulae ='[INF_Cap_8400-8051.xls]Infra Cap'!$C45 BUT instead of using the workbook to link to the cells of interest I would like to use text in Cell B1 for example. <TABLE style="WIDTH: 127pt; BORDER-COLLAPSE: collapse"...
  4. B

    Excel Linked Cell Reference is lost

    We have a problem with linked cells. We have a main spreadsheet which links to other spreadsheets, the problem is that occassionally the linked cell refrence is lost and the cells are replace by #Ref. Can anyone help please.
  5. WERNER SLABBERT

    I have need of some know how...

    In a project i am compiling i need to work accurately with times to calculate the work progress of the people in the workshop thus....here goes.... I have in work book #1 (7) sheets mon to fri + complete week + a sheet where all job numbers are collected. From monday to friday the workmen log...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    • Replies: 40
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    • Replies: 35
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top