Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   Moving Links in Excel Hello! Can anyone help me figure out how to lock hyperlinks to a text instead of to a cell? I am creating an inventory list (with List Maker) in Office Mac 2004 Excel. I need to link the name of the product (in Column A) to another Excel sheet with details about the product. The links work fine, but if I add additional products, the links move with the original cells - not with the product ... 2 19.08.2006 07:34:08 Expanding links??? Hello folks, I need to link from data in Excel into Word, however, I need to be able to show various lines of data in the link, so sometimes there maybe 10 lines of Data in the Excel spreadsheet, but other times there maybe 15 lines of data. What seems to be the case is, when you create the link, it is cell specific, so you link to A1:D14. So is there a way I can show 10 lines of ... 2 16.08.2006 23:50:16 Excel data reformatted in Word mailmerge G'Day, I'm using an Excel worksheet as a data source for merging into a Word document. Some cells are "formatted" to contain blank lines (entered using Alt-Enter) to act as paragraph separators. During the merge these blank lines appear to be removed. E.g. First pice of text. Second piece of text. Third piece of text. becomes, after the merge, First pice of text. ... 3 16.08.2006 22:18:16 Network Links I have a number of Excel files on a network server which it is mapped on my PC as the 'H' drive, however for some users this drive is mapped as their 'K' drive. I have created links to various Access databases for which they auto update when I open the Excel spreadsheets. However when users (who see the drive as 'K') try to open this file, they get an error stating that the file cannot b... 7 16.08.2006 14:03:02 Updating the source of a linked cell Hi all, I have a question about linked cells. Let's say that I have a cell B2 with value 5. I have another cell C4 which I want to display the value of B2 but also be able to change its value if I enter in a new value. I'm pretty sure it's not possible, but I thought I should ask people who are more familiar with excel. I think this is useful if you want to display values from a range in... 2 15.08.2006 23:49:27 Fax an excel sheet to a fax number as a cell vaule I am trying to set up a macro that will send a fax of the current sheet to a fax number which is a vaule in a cell (i.e E12) I could use MS Fax or Winfax. Any ideas please ... 1 13.08.2006 07:49:49 Moving file locations We have a need to move a number of spreadsheets that have hundreds of links in each of them and I am wondering if there is a utility that can be used to re-establish the links if the correct information is given. Thanks in advance.... 2 08.08.2006 23:45:39 Opening Protected EXCEL worksheets to update linked data I have the following code that should open all EXCEL workbooks in a specified path, and unprotoect any password-protected worksheets to allow for Link Updates, then close the workbook after password protecting it. For some reason, I can't get this code to work -- any ideas? ================================ I put the following code in a general module of a sheet1 of a workbook sub Updat... 10 07.08.2006 09:51:15 Try this new excel tutorial Try out this new excel tutorial which is still under development http://xlmaster.blogspot.com ... 1 05.08.2006 13:05:17 automatic links is there anyway you can see what links to other workbooks are associated with the workbook you have open. The problem i am having is when i open the workbook in question a message appears and states "The workbook you opened contains automatic links to information in another workbook. do you want to update this workbook with changes made to the other workbook" Yes....... No. if i click N... 3 04.08.2006 13:57:27 Use Excel cell values in a Word document I have a Word document that I want to link up with data from an Excel spreadsheet. For instance, say I have a sentence in a Word document like: Last quarter the foreclosure rate fell by ____ basis points to ____ percent. I want to fill in the blanks by using specific cells in a spreadsheet. The data will change every month, so I thought I could automate the process instead of keying it int... 2 02.08.2006 23:39:06 Multiple page entries I've been using the same 88 page workbook for about 2 years, in the same way. Today, when I entered any data, it was entered across all 88 pages, on the same line that I originally entered it. Unfortunately, I didn't notice it until I had already saved a few times. How do I stop Excel from doing this. I did not make any changes other than entering data. ... 2 01.08.2006 07:21:16 Hyperlink display I have the file path to several files of mine in columb A. In columb B, I use =hyperlink(A1) and copy down. The hyperlinks work fine but I only want to display the actual file name. example instead of - G:\Staff Duty Book Folders V2\Book Cover.doc I want it to display - Book Cover Any suggestions I am totally lost on this. Thanks in advance ... 4 30.07.2006 22:49:38 no resources Hi There I have a problem that has just started. When I have two or three spreadsheets open if I try to copy off one sheet toanother it says not enough resources. As I say this has only just started and I have to close down and only have one workbook open at a time. Which is no use as I need to copy data from one workbook to the next. Any help would be appreciated. Many thanks in adva... 1 29.07.2006 21:22:33 Invalid Names I've tried deleting links via the Links Dialogue and the Defined Names windows and I 've tried using code to delete the names. But my code returns an error message stating "That name is not valid". It is referring to a defined name such as " " or "+" Anyone have thoughts on how to delete these invalid/bogus names? Thanks for any input. ... 6 28.07.2006 14:29:10 Source not found Excel 2003 SP2 The problem relates to a workbook not being able to access data in a linked workbook that resides in a different sub-directory. I have five workbooks each created and residing in the same sub-directory. Workbook 1 is a 'Menu'. Workbooks 2, 3 & 4 are a 'Form' Workbook 5 contains 'Data' When the 'Menu' workbook is opened, a macro automatically opens the password to... 1 27.07.2006 09:31:02 links to hyperlinks not working Hi, I have a excel which stores URL and its short description. I need to have a cell in other excel to have the "short description" from first excel and when I click on that it should go to URL given in first excel. I used farmula in cell of second excel like following: =HYPERLINK('\\abc\[excel1.xls]sheet 1'!$G$7,'\\abc\[excel1.xls]sheet 1'!$F$7) This works only when first excel ... 1 25.07.2006 14:10:12 Excel Addin for Access Links I now use Excel 2003. BAck in Excel 2000 there was an add-in "Access Links" which allowed conversion of Excel Listfile data to an Access table. I cant find an equivalent in 2003. I know I can import into Access ( that is "pull" the data into a table) but it's more important for me and my users to be able to push the data from Excel into Access. CAn you give me any help to acheive this??... 2 22.07.2006 22:52:57 Unable to Read File I am having a problem linking one workbook to another. Let me lay it out... I ahve a database that runs a query and then uses a macro to "Output to" the query results to a excel file called CARQuery.xls. Once that is done A user can then open a different excel file that links to CARQuery.xls takes its data and oganizes it So a Chart can use it. The Query works fine, the Output to works ... 2 22.07.2006 06:33:29 Copy Formula with Linked Cells - Validation Question Win XP; Office 2003 Paste formula from linked files. This is the command I'm using: on the destination file; highlighted the cell with the formula --> click on the copy icon --> place cursor on upper left of cell, then drag to the other cell locations --> select the down arrow next to the paste icon --> paste special, select the formula and transpose boxes. This w... 1 21.07.2006 14:24:01 External Query Definition Disappears I use many external database queries in my worksheets. To refresh results, I simply right click in the data and select Refresh. Sometimes, however, after the refresh, I right click again and find that the query definition has disappeared, meaning the worksheet thinks I've returned text only and there is no option to refresh any longer. I keep archives of my queries so I can copy/paste b... 1 20.07.2006 15:02:02 Trouble Updating Linked Spreadsheets I am working on 2 Excel files with multiple tabs and spreadsheets going out to Col. EU. I don't have any problem when I am working on these files at my home computer but then when I email them to others, the links are still attached to my computer and therefore, it appears, cannot be updated. This means if any #s change in one file, the other file is not updating for those changes. Is there a... 3 20.07.2006 02:39:57 Excel Queries I created an excell file, and I am refreshing the excell queries using ActiveWorkbook.RefreshAll function, but everytime I need to enter the username and password, is there a way to avoid enter the username and password for each refreshed query, or just enter one time only??... 5 14.07.2006 22:45:44 Running Macros I have the following Macro (which I need to run on approximately 200 different workbooks) -- what is the BEST way to achieve this? Should I use a Function (and if so, what would it look like)? NOTE: I'm assuming that this Macro should reside in a Module -- but, should this be run outside of EXCEL (say, from a Form in ACCESS)? Here's my code: Does anyone see anything that I may be... 4 13.07.2006 22:30:05 test test ... 2 13.07.2006 09:51:18 9 Pages: 1  2  3  4  5  6  7  8  9