Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Showing hyperlink when using lookup I have one sheet that has a list that contains some text that has hyperlinks and then I use lookup ona different sheet, but when the text is displayed onthe second sheet the hyperlink is not there. Is there a way of keeping the hyperlink on the second sheet. The hyperlink uses tags.... 2 12/29/2008 6:39:31 AM link updating on workbook open Hi, I have several files on a network server that contain links to a master file, also on the network server. I've set the Startup Prompt value for the link to "Don't display the alert and update links" with an automatic update, intending for the files to be automatically updated when opened. This works as intended when I open the files from PC #1. However, when I open the files from... 1 12/23/2008 12:55:10 PM Hyperlinks Randomly Change Operating system is Windows 2003 with MS Office 2003. We have numerous Excel workbooks with multiple spreadsheets in each. We have many hyperlinks within each spreadsheet that links to many different directories/folders thus, not allowing us to use Hyperlink Base. When we establish the links they work for days, weeks, months, but then for some unknown reason the links change. We have... 1 12/23/2008 5:02:03 AM Valid Hyperlinks being reported as Invalid Because of problems with hyperlinks randomly changing without any intervention a VBA procedure was written to perform various validation checks on the hyperlinks. One of the checks is to see if the link actually exist and if not report an error. Following is an excerpt of the VBA procedure: For Each h in Worksheets(curwksname).Hyperlinks If (Dir(h.Address) = “”) then ... 1 12/23/2008 4:45:01 AM Password Protected Links User has Excel 2002 SP3 His workbook has multiple links to other workbooks that are password protected. He wants to know if there is a way to incorporate the password into the link. Any ideas?... 3 12/22/2008 5:23:01 PM Setting up an Excel sheet to automatically determine when an employee should enter a retirement plan, perhaps What-If Analysis would help? Any other suggestions? Perhaps a What-If analysis would help with this, but the situation that presents itself: For retirement plans, usually a person must work one year of 1,000 hours before that person can enter into the retirement plan as a participant. However, plans usually have set dates of entry, usually twice during the year. Therefore, a person enters on one of those entry dates subsequent to his attain... 1 12/21/2008 12:28:10 PM saved files loses hyperlinks We have an Excel spreadsheet on our network with working hyperlinks. One user moved it to his folder (still on the network) to make some changes. The hyperlinks still worked at this point. When he was done with changes, he did a "file save as" back to the original network location but the hyperlinks no longer work. I have looked at Security and drive mapping but cannot figure this on... 1 12/18/2008 6:48:03 PM Excel LOOKUP Question I have a need to do what I believe is called a two dimensional search. I want to populate a cell with the contents of a cell that exists at the intersection of a row and column each of which contains a known value. I've come to the conclusion that a combination of the HLOOKUP and MATCH functions should do it. However, I don't seem to be able to get it to work. Here are the real Excel ... 2 12/15/2008 8:38:38 PM Filter an array I need to filter the results of my array. I have a column "DOI" that is a date and I need the array to only display the blank/null values into my new sheet. ie. IF(DOI=Null, DOI) I also need to be able to bring over the Incident and owner columns only if the DOI column is blank. I am assuming that it would be an IF statement for the array but am having trouble getting it working.... 2 12/13/2008 12:48:01 PM Unnecessary error message on opening file with links Hello, apologies if this has been asked before, but I have multiple files with links to other files. Every time I open the file I get an error message ssaying " The workbook contains one or more links that cannot be updated" with options to continue or edit links, when I go to edit links all of the connections give a status of 'OK'. This happens regardless of having some of the linked fi... 1 12/12/2008 10:58:01 AM Word O7 looses links with excel 07 when files copied to network fr I create links in word 07 with Excel 07 that update on my C drive. They work and update when I change data in Excel. However, when I copy and paste on to our network the links do not transfer. The edit links in word still shows links to the C drive. Any ideas? Brian ... 2 11/28/2008 11:15:22 AM Can't use excel I can't change some of the worksheet settings because these is no printer connected to the computer. Is there a way to get around this? Ralphael, the OLD one... 5 11/26/2008 8:15:40 AM hyperlink printing excel Hello, In my sheet I've got a list of hyperlinks linked to pdf files. I wondered if it was possible to automate printing of these pdf files by clicking on an adjacent cell. So i was thinking, in one cell you have the hyperlink to the pdf file and in the cell next yo it you can print it automatically by clicking there. Thanks for any help!! -- deer... 3 11/25/2008 8:38:20 PM Excel: External Network Links I've started creating reporting files on Excel 2003 which are shared via Mailsite 8.0 which link several files to one summary file. Currently the file works when I open it, but not when another person opens it from their computer. Ideally, multiple people would be able to access the summary file with working links, and the correction could be easily applied to other similar file relati... 4 11/19/2008 7:31:24 AM Link shows formula instead of content of cell In the same workbook, I created links from one worksheet to an other. For some of the cells (all in the same column), instead of seeing the content of the cell, I see the formula as in the formula bar. For example: In the cell D12 of a worksheet called 'Summary', I want to make a link to the value that appears in the cell D12 of the worksheet called 'Revenues - Retrieve'. The result that app... 3 11/14/2008 3:00:14 PM Import Data from HTTPS Hello all I would like to import data into an xl sheet from a new web query. I am trying to use the option “Data -> Import External Data -> New Web Query”. In the “Address” field of new window popped up, I pasted my website as " https://marketdataresearch.credit-suisse.com/cs/mdr/p/d/stm/stockmarket/commodities.do " and press “Go”. It is then asking “Do you want... 2 11/13/2008 3:03:22 PM Weird Links Behavior This is one of the strangest problems I have encountered in Excel, and am wondering if anyone has any words of wisdom regarding this issue. I have three files: File A, B, & C. File A is linked to file C. File B is linked to file C. When I open File A alone, it shows the correct linked values. When I open File B alone, it shows the correct linked values. But when I open File A, and then... 6 11/13/2008 8:44:57 AM Macro for deleting rows and serialising the remaing rows Macro for deleting rows and serialising the remaing rows ==================================================== I have a spread sheet It's a ToDo List The structure is like this Column A Sl No Column B Task Column C Person Column D Completed To start with I keep entering the tasks in one stretch and take a print out. The first Column (A) will be a serialized. ... 2 11/13/2008 8:44:55 AM Named Range Links not working I am unable to have a link to a named range in Excel 2007 work from any external location. When selecting a link to a named range from Internet Explorer, or by UNC path in our Wiki, the Excel 2007 workbook opens to the last cell selected when the file was saved and closed. I have been scouring the web for this issue and have not found any information on it. The same workbook in Excel 20... 2 11/12/2008 7:49:12 AM Links not updating automatically Hi. I have a 7-workbook Excel spreadsheet, which contains links to several other spreadsheets. When I open the document, I click Yes to the "Do you want to update links?" question, but the information in the linked cells is not updated. However, if I click on the cell, then click at the end of the link in the formula bar and press Return, the link updates. I've checked that the "up... 10 11/11/2008 5:45:01 PM Link a column not cell by cell I have a workbook with over 50 columns and have a report on a weekly basis that I only need to show 7 of the columns for. I don't want to have to hide and unhide the other columns every week. There is constantly more rows being added to this workbook so just doing a drag on the cells will mean that I will have to do the drag every time to catch the new rows. I would prefer to just lin... 2 11/10/2008 11:50:01 PM I can't find Notebook Icon I sometimes need to empty my notebook but the Notebook Icon is nowhere to be found. Any suggestions? Ralphael the OLD one... 1 11/10/2008 11:17:33 PM Excel losing hyperlinks when I sort the worksheet Hi, (Sorry for the crossposting, but I felt this post applied to both newsgroups...assuming excel.links means "hyperlinks") I have an Excel worksheet with about 1000 rows. One of the columns contains hyperlinks. The text of the hyperlink is the URL - IOW the displayed text and hyperlink are the same. When I add new data to the worksheet, I need to sort it by a particular column.... 4 11/7/2008 9:40:53 AM vlookup from Access db Hey there, I reckon the subject asks it all, but to explain further: I have barcodes in Excel in a column. Next to each I need to put a sales volume, which must be "vlooked"-up from an Access db. Is this possible? E.G. in Excel BarCode Volume 123456 20.00 (formula) In Access BarCode Volume 123456 20.00 Thank you for any help!... 4 11/6/2008 3:14:30 PM Inserting Pictures onto a spreadsheet. Hi All, I have been reading many posts about using code to insert pictures from a folder into an area of a spreadsheet and have made them work according to the many people who have posted here. Most posts say that either you enter a name or number in a cell that corresponds to a pic, or use a data validation box to do a lookup. Again, I have made each of these methods work. My question:... 16 11/4/2008 2:00:03 AM 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13