external

  1. S

    Refresh pivot table external data with encrypted password

    I have 10 excel files that contain a table with many columns and many rows and that need to be updated frequently with new data. In order to have a faster record of some data from these files, I created a separate excel file that centralizes them all 10 files by external pivot table data and...
  2. D

    Can you open an external wb, retrieve a drop down menu then close it

    I have a wb with a drop down menu that correctly references an external wb to get the list but the external wb needs to be open to do so. It is going to be used by more than one person and will be stored on a server. Is there a way to have the external wb open when the cell with the list is...
  3. S

    how to import data from external excel source?

    Hello, I want to create a command button in my excel find to find necessary values in an external excel file. as in many programs, I would like to click on the open file option and select the target file with the windows search interface. as an example I installed a page of a simple windows...
  4. G

    Erase values linked to external files

    Hi all, I wonder if there is a code for doing the following: I have a WB called WB1 with Sheet1 with links to another WB, called WB2, Sheet2. Is there a possibility to delete all the values that came from this external file (WB2)? I mean erase all of them quickly. Thanks in advance!
  5. Nelson78

    Application.SendKeys "{TAB 2}" does not work

    Hello everybody. I'm a newbie about automating external application via sendkeys method. Now, I can get in the external application, I can write (for example "5"), but I cannot shift the focus two fields on the right (as I manually do without problem). I mean: nothing happens. Maybe somebody...
  6. J

    Finding Excel files with external links

    All, My administrative department has a bunch of Excel files with links to other Excel files in a variety of network folders. They want (need) to move the files to a new server. I'm thinking that if they move to the new server, all of the links will be severed and they'll need to re-link them...
  7. N

    How to change dynamically excel external file name change daily as the date

    Hi all, I am a beginner to this technology VBA Excel. I faced a problem in the project Read an external file and look for a Specific String (This external file name will change daily – as the Date – which will be part of the file name – will be dynamic) Return a Value from the 8th Column...
  8. H

    Restarting page numbers part way through report

    Hi folks, We have a report which consists of 10 sheets. Several of the sheets may vary in the number of pages that print. For example sheet 4 in the series may print 1 or up to 5 pages (varies with each report). For example: Sheet 1 - 1 page Sheet 2 - 1 page Sheet 3 - 1 or 2 pages Sheet 4 - 1...
  9. U

    Break External Links only in Certain Cells

    Good morning, I have a worksheet which links to other worksheets for its calculations. I already have a macro which deletes all external links, but I'd like one that deletes just external links from a certain worksheet, as that worksheet pulls in many values and can slow the program. The linked...
  10. R

    Macro to replace value on sheet with a value from another sheet

    Hello All.. Quick history: We have assets that are known by what we call "external" name. This external name is an unique identifier. But... When our oracle database was created, this external name was not used has the key field, another "internal" name was used. Example External name = 987654...
  11. T

    Musings on behavior of external references in cells in OneDrive shared workbook on Windows/Android

    I don't really have a question here, just wanted to share this experience, partially as a warning, but if you have any comments on how to improve, please post! Its a bit hard to describe but i'll try to simply. Its "complex and intricate"...and unfortunately "irregular and unpredictable" in...
  12. J

    Data Dictionary Best Practices

    This is probably something simple but I just wanted to know all my available options. I own and maintain a data dictionary that I keep on Excel. There are around 12 columns, all with headers. The columns are meant to identify all the attributes of a particular data element. Each row is a...
  13. A

    Saving Issues

    Hi all, Im not sure if this possible but any ideas would be amazing! I have a sheet that is used by a colleague of mine and she keeps accidently saving it in random places which breaks all of the external refs. Is there a way to set the sheet to only be able to be saved in one location? Im...
  14. M

    Vlookup - display previous value if zero

    Hello, I have an external connection pointing to an xml which display some values. Sheet1: Values Sheet2: External values I managed to do it with Vlookup but since the XML sometimes doesn't updates correctly and points to "zero" (since it can't read it from external source) I will want to...
  15. N

    can i set a custom background for a cell from external file as a fill?

    can i set a costume back ground for a cell from external file as a fill?
  16. H

    How to question: Break External Links ONLY on specific tabs

    As the title reads, i'm looking to see if there is code to break external links only on specific tabs in a workbook. I have found a few codes on this forum, however, they all break external links in the entire workbook - not specific tabs. I can provide these code if necessary. Thank you!
  17. D

    External Links

    Hello Board, I have just taken over a workbook and on checking it, I can see there are around 90,000 cells that have links out to data in another workbook. is this the best was to have one workbook update another?
  18. B

    Updating Hyperlinks When Page is Copied

    I have a rather large workbook that has a 'Template Page' where the default page styling, formulas, and tables reside. I have a Macro that clones the page, and then auto updates the formulas to refer [NewPage] instead of [Template] page. All works well, no issues. Then now they want to put in...
  19. D

    Sharing/Permissions on PowerPivot Workbooks

    I'm very new to PowerPivot and the underlying data structure, so forgive me for missing any obvious answers here. I'm replacing a manually updated workbook with a data model and PowerPivot features and ultimately going to be sharing a dashboard-like file with external users. I want them to be...
  20. M

    Issues saving userform data to an external workbook

    I am experiencing problems when multiple users are saving userform data to an external workbook. I included error coding that informs when the save has failed and to try again which appears to work but now and then the workbook opens twice - and the message the workbook is already open is seen...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top