| Thread | Last Post | Replies |
|
| Emailing an Excel Workbook with Links | 29 Jun 2007 15:54 GMT | 2 |
When emailing an excel workbook with links to other workbooks, the drive of the linked spreadsheet is being changed. For example, the attached spreadsheet would be linked to another spreadsheet in a shared drive, "M:...., but when the file is sent
|
| How to find if workbook is being linked to | 29 Jun 2007 13:14 GMT | 1 |
I need to make some changes to a Workbook A but don't know how many other workbooks link to it. I'd like to open the other workbooks before I make the changes Workbook A so the links don't get messed up.
|
| Avoid Update Links dialog in Excel 2003 | 29 Jun 2007 13:11 GMT | 3 |
I have a workbook with links, and I don't want to be asked whether I'd like to update these, as the Workbook_Open event will open them in any case. I've set the "Startup Prompt" for this workbook to the bottom (3rd) option, but I still get asked every time. Any idea why?
|
| Linking CSV file | 28 Jun 2007 11:35 GMT | 7 |
I run W2K with Excel 2K. I have a workbook that links to a file on a server. The file on the server is a file that is downloaded from a mainframe in a CSV format. Also, although this file is a csv format it has been setup to download with a .XLS extension.
|
| Bring a total from one page to another. | 27 Jun 2007 04:22 GMT | 5 |
I have a work book with allot of pages and want the total amounts from the various pages to self add on a single page for quick viewing instead of going to that actual page and scrolling to the very bottom to see the total.
|
| Text Truncated after Paste link in Excel 2002 | 24 Jun 2007 14:01 GMT | 1 |
I have a excel file, which reads from many other excel files (created and updated by other users). I use Paste Links to read the data I need from the source files but due to 255 character limit the text string
|
| Changing formula links | 19 Jun 2007 00:29 GMT | 1 |
I have a master spreadsheet that calls on another spreadsheet(a) a completes the calculation, the problem is it is pointing at the wrong spreadsheet, spreadsheet(a). When I open up the correct spreadsheet, spreadsheet(b) and select the
|
| Place source to drop down list in another spreadsheet | 17 Jun 2007 00:53 GMT | 2 |
What do I do when I wan't to use validation from a list, but I do not want the list to be visible on the spreadsheet? If I hide the rows containing the list, the hidden values also becomes hidden in the list.
|
| Iserror does not work for missing sheets in linked file | 13 Jun 2007 18:31 GMT | 1 |
I have a file with links to another file. The formula I have tried is: IF(ISERROR(SUM('C:\Temp\mainfile.xls]sheet1'!$AT:$AT)),0,SUM('C:\Temp \otherfile.xls]sheet1'!$AT:$AT))
|
| nested links | 08 Jun 2007 16:14 GMT | 1 |
I have a worksheet that is linked to 4 different worksheets, each of them contains links to another 10 worksheets which contains links to other worksheets. There are no circular reference amongst them but there are 4 levels of links
|
| Linking Word and Excel | 07 Jun 2007 15:53 GMT | 1 |
Hi all, This seems to be an easy bet for most of the Excel users, but it i really not for me. I created a Word file. Now i want to put a hyperlin to the SECOND work-sheet of another excel file, which is saved in sam
|