Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   Linking from one sheet to another. Can I to get a total from every sheet in a workbook into the last sheet, while having Excel automatically update when a new sheet is added to the workbook? Example: I've got 4 sheets with an amount in cell V3, and I want the total of all of the V3's to show up in a specific cell on a fifth sheet. If I add another sheet containing a V3 value, can Excel add that automatically to the formula on t... 6 15.05.2006 23:50:04 Excel worksheet retrieving data from Access I am very new to this, actually my first post "here". We have a relatively large Access database file that holds our customer information. We also use excel as our online ordering tool. I would like somehow for the excel worksheet to keying a customer number and all relavent information will be retrieved from the access database. Is this possible? Are there tutorials around this. Keep in... 2 07.05.2006 23:32:27 Links not Updating Hello Excel Mavens, I have worksheet linked to another workbook. I have an equation that pulls data from that linked workbook. When I open the workbook, the data does not get updated and I get the #VALUE error. If I open the linked workbook the data updates. Other linked equations (to the same workbook) refresh perfectly. The equation is:=COUNTIF('S:\[Nov 05 Recap.xls]Sheet1'!$E$7:$G$21,O... 3 01.06.2006 14:09:02 Replace hyperlinks with actual pictures Hi, I have a worksheet with a column of hyperlinks to pictures (http://server/image.jpg, http://server/image2.jpg, etc.) I would like to create a macro which replaces all the hyperlinks with the actual pictures, or inserts them into an adjacent cell. I can easily loop through the hyperlinks with For Each h In Worksheets(1).Hyperlinks but I have not found a way to replace these l... 3 30.05.2006 18:50:42 Updating external links I want to create external links in a bunch of excel files (50-100) to one central workbook with lookup tables. Is there any tricky way to make the sheets search for the lookup table workbook (such as by name) in the event the file structure changes, i.e. if the file are moved off the network onto a cd. The lookup worksheet would always be kept in the directory with the log files. ... 2 30.05.2006 06:41:55 Amalgamate Several Worksheets into one file thru Data import I am having 12 files in different network locations. Each having one worksheet inside. I just want to know whether I can create one file in my hard drive and create 12 worksheets and Import External Data to each worksheet from the different files so that I can see all of those worksheets in indifferent network locations into one file. I tried the External Data Import & Refresh but the co... 2 29.05.2006 10:08:12 Make "Insert Hyperlink" remember the last location Hi, Say I have my excel sheet on the Desktop. And I want to link to two documents in "My Documents". I go to a cell, right click, hyperlink, get a box that says "Insert Hyperlink", this box shows my Desktop so I browse to "My Documents", choose the file, and link it. Now I go to the next cell, right click, hyperlink, and I get a box that again shows my Desktop. Is there any way I can ch... 2 26.05.2006 23:40:26 empty copied/linked cells contain 0 I am attempting to link a few Excel files to a worksheet in a separate file that contains my master data. The link works, but, empty cells in the range selected now contain a zero, in the target files. How do I prevent cells from being zero filled? I have set columns to TEXT. Excel 2000. Thanks... 2 25.05.2006 16:15:25 Excel to HTML link - and back? Hi! I have a small problem here which I have to solve this afternoon, so thank you for your ideas. When I link from an Excel page to a webpage, this works fine. If I then press the back button, the IE is unable to go back to the excel page - "unable to open xyz.xls". How do I circumvent this problem? Best regards, Stefan ... 1 24.05.2006 14:14:20 Where ARE the links Excel mentions Hi group, I often re-use good workbooks that need only minor modofication to fit for a similar project. One problem I have run into several times is when Excel gives me a warning, on opening of a workbook, that there are links to other workbooks that could be updated or not. Is there a quick way to make Excel display the cells where those links are, so that I can modify them? Tia ... 3 24.05.2006 04:49:38 insert zero Hi can you help i have a range of numbers and need to insert a zero in front is there a way of doing this sample 07011117050 ... 2 22.05.2006 19:55:30 insert zero before number hi there i need to insert a zero in front of a range of numbers 7011117050 7011117051 7011117052 7011117053 also they will not drag to the next number in sequence thanks ... 2 22.05.2006 19:53:54 Automate Hyperlinks to files I have a spreadsheet that contains a list of numerical values (i.e.) along with other data. App NO Type Title etc. 5963369 Cats The cat's life 8963369 Dogs The doghouse 4569933 Birds Flying Each cell contains a value. I need to hyperlink each numerical value to a pdf file with the matching numerical value. There are 350 files. Is there anyw... 2 20.05.2006 14:50:23 linking multiple workbooks How can I link cells from multiple workbooks into 1 workbook? I want to link information from many workbooks into 1 workbook to make a sumary of all the information. All help will be apretiated. thnx ... 3 19.05.2006 22:46:34 How to make an external link to a filename defined by a cell value Hi, I haven't been able to find a way to do this in the Help resources I found so far: I'd like to have a "report" workbook importing data from a number of other "data" workbooks. I can make the external references manually, but that would take a lot of time, and would have to be repeated every time there is a new "data" file. Is it possible to just write the filenames in certain ce... 4 17.05.2006 22:38:27 Removing/Resolving Links before Copy Excel 2003. I have workbooks in which there are internal links (cell references and references to labeled cells). I would like to "freeze" these before copying these sheets to another workbook. How can I resolve the internal links or references so that the references are no longer there, only the actual values the references produce? Thanks for the help and God bless. -- Dr. Doug Pr... 2 17.05.2006 22:38:26 Add link to specific Excel worksheet in HTML Outlook message This request involves Outlook 2003 and Excel 2003. I send "cut & pasted" Excel spreadsheet data to various mail recipients via HTML messages. Since I run multiple computers on my network, I also have an add-in app that BCCs all my messages back to me. In order to reduce the size of my PST file, I prefer to go back into those messages and delete the actual data, but insert a link to the ... 4 17.05.2006 06:55:00 Sorting loses links to data In Office 2000, I have links to cells in an Excel list. When the list is sorted, the links remain to the cell references, so show different data. I want the links to follow the data when it is sorted, so I guess I somehow need to link to data and not cells.... 3 16.05.2006 08:04:02 Absolute value changing in linked workbooks I want to link Row 3 in workbookA to Row 5 in workbookB. In WorkbookB cell A5 I have: =+[WorkbookA.xls]Sheet1!$A$3 The links are working except when I insert a row above Row 3 in WorkbookA. It changes the absolute reference to $A$4. I want it to remain linked to row 3. I would appreciate a suggestion.... 4 15.05.2006 23:50:06 Using an Excel email hyperlink with Mozilla Thunderbird Hi I've got a hyperlink setup to email to multiple recipients: mailto:dfewx@madasafish.com;mail@dfx.you.uk When i click on the link it opens the Thunderbird 1.5 Compose dialog & adds the addresses in the To..., but it adds an erroneous " before the first @ e.g. dfewx"@madasafish. It doesn't do it if I set Outlook or OE as the default mail client or if there is only one address in... 1 11.05.2006 20:55:48 Linking infor from spreadsheet into word I have info on a worksheet in Excel 2002 and have linked this to a word document. I have formated the word document but when I make changes to the worksheet and update the data from the linked file my format is overwritten. Is there any way around this??? MMC ... 2 10.05.2006 09:58:05 Sorting Referenced Cells Hello, I have run into a road block while creating an excel document. I have done ample amounts of research in a lot of forums, but I am not finding the same situations as the one I currently have. If the same situation exists, can you please point me in the right direction? If it does not, I appreciate any help that can be offered. Below I will give you the background, scenario, and probl... 2 06.05.2006 11:44:12 Importing information from 2 workbooks into a 3rd one Hi, I need some help with importing information from 2 different workbooks into a third one. The problem that I have is the following: the reference points from where the information needs to be pulled from are not the same cells every day but information in column A that point to the information in column B in the same row that need to be pulled into the 3rd workbook. In Detail: in ress... 3 28.04.2006 23:57:01 External data retrieve timescale Is there any way to lower the Refresh External Data time to below 1minute? Thank you. Richard ... 2 27.04.2006 12:44:35 Change in Link Behavior - Excel 2000 to 2003 I recently upgraded from Excel 2000 to Excel 2003. One of the spreadsheets I've worked with using Excel 2000 has many links to other spreadsheets, all of which are created based on a mapped drive letter (S:), which is mapped to my Public folder. After opening the spreadsheet in Excel 2003 many (but not all) of the links have changed to the UNC (\\servername\public\...) to replace the S... 1 27.04.2006 03:41:01 9 Pages: 1  2  3  4  5  6  7  8  9