linked

  1. H

    Insert rows with formulas based on a cell value

    Hey, Please I need help in this case; thank you in advance! I insert data and have the data in Table1 in Sheet1: <tbody> A1 DATA B1 Order =COUNTA(A2;A1000) (result: 2) A2 Car 1 B2 25 A3 Car 2 B3 45 </tbody> Every time I insert new data, new data might add/cut rows to/from this table...
  2. S

    How to Link your Access DB to Sharepoint?

    I have never attempted this before. But, is there a way to place your Access DB on SharePoint, but have it linked to where it saved in the folder its linked to? Also, multiple users should be able to open it correct?
  3. A

    add anew row whan fill data from userform to sheet

    hello i have userform contains combobox1,2,3 and textbox1,2,3 the sheets contains 6 columns a,b,c,d,e,f i would code to add data from userform to the next row in sheet1 the combobox 1,2,3 linked with range from a20:c20 and textbox1,2,3 linked with ranges from d20:f20 every time i fill data in...
  4. T

    linked table error

    Hello, I am running into an issue where when I tried to enter data in access database, it keeps showing up the pop-ups "name of the data.accdb" is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides". I have...
  5. D

    SQL Linked table

    Hi All, I am new to SQL but learning quickly. I have a spread sheet that has on tab linked to an external SQL database an several other tabs with static data When I run the following "select * from linked" (this I the linked sql data) I get no results, however if I do "select * from...
  6. J

    Table Compare

    Hello all, I am working on an addition to the massive dBase I have, a query that compares two different tables, linked by a name field in each, and performing a datediff function. For the most part I have this working. The datediff is operational, but the slight issue and question I have is...
  7. G

    Excel-Word linked

    When I run spreadsheets I create tables and charts in them. I format them as desired, then cut/paste them into a Word document. But I have found that the Word document and Excel file are "linked," which I don't want. The last time I copied the Word doc onto a usb driver to work at from home...
  8. S

    Scroll/Drag check boxes down and link to the new cell

    I am making a rather large list with checkboxes which is working well. When I want to expand the list, I have to individually edit each check box to be linked to the new cell. Is there a better way for when I drag a cell down by the bottom right corner that the new check boxes are linked to the...
  9. R

    Linked cells not updating values after copy/paste into source table

    Hi all! One of my colleagues has issue since some days: It's simpel: There are 2 Excel files: One to copy data from and Excel Masterdata file The Masterdata file has 2 sheets: one with all the data and one with all the data but with linked cells to the first sheet. AsWas: You could copy a...
  10. Sanjeev1976

    Excel to Powerpoint - Link and editing range

    I have made different scenarios in Excel, which are then linked to a Powerpoint presentation. I'm trying to get the listing of these ranges of various links in the excel file. And the possibility of modifying the range in the links, which will then get reflected in the Powerpoint presentation...
  11. E

    Adding 7 address fields to one row

    I have a list with single rows, each having name and other details but need to add / link up to 7 addresses for each person. I'm wondering what would be the best way to organize this without hopefully going into new linked excel files for each entry. Any ideas?
  12. Mel Smith

    Sharing linked workbooks

    I have a number of linked workbooks that I need to share with one, or possibly two, other team members. We work in different locations. I have trialled sharing these workbooks with one colleague via OneDrive, which wasn’t without some problems but I wonder if there is a better/smarter solution...
  13. D

    How to link mutliple sheets to huge data table

    In workbook, I have about 20 sheets that all have formulas (vlookups, sumifs, match etc) linked to one sheet (10,000+ rows) But everytime I make a change in any sheet (e.g. number format, or dragging down formulas), it takes a few seconds to calculate. Is there a better way to have the sheets...
  14. A

    Excel Message When Opening Files

    Hello. When opening Excel files that contain links to other files, I often get a message in the lower right of my screen that says "Linking: (file name)" with a status bar (please see attached photo). This would not be a problem except that Excel seems to "pause" at this point for several...
  15. M

    Any chance mdb to get data from xlsx

    I know accdb is better to be used to get linked data from xlsx. But for some reason my platform can only use mdb. Anyone got any experience mdb can also get linked table data from xlsx ? Help...
  16. B

    Coding in an employee count month by month and per region/department

    Thank you for reading my post. Need to count the number of employees in each month, by category and region. I have linked below a worksheet which hopefully demonstrates the problem best. https://1drv.ms/x/s!AtncZKajpjWngrAPs8RZSmOhLO4VWA
  17. H

    Percent (%) displaying on linked sheet on one PC but not on another

    I have a workbook, where I have several sheets that links to items on sheet 1 Sheet1 contains values as well as percentages The values and percentages are displayed correctly on the linked sheets on My PC, but the percentages are displayed as values on the linked sheets when copied on to...
  18. D

    Missing linked data file

    I am trying to help out a coworker who has an excel file embedded in powerpoint and when she tries to edit her graph that's in powerpoint she gets a pop up error that states, "The linked file isn't available". She states that she has always accessed the data via this route and has no idea where...
  19. M

    VBA to Refresh Data of PowerPoint Charts linked to Excel

    I have a PowerPoint with many slides that have charts linked to data in Excel. Periodically the excel data will be updated - instead of manually going through each slide, selecting each chart, and selecting "Refresh Data", I would like to create a macro that automatically refreshes the data for...
  20. M

    Running VBA script every time a linked cell is updated through a combo box selection.

    So I have an issue in my excel file where I have a cell that is bound with a combo box. Every time the combo box selection is chosen, the linked cell will, of course, automatically contain the contents of the combo box. I then want my VBA script to automatically open an excel file on my desktop...

Some videos you may like

This Week's Hot Topics

Top