Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   File path of external link changed Hi all, I have an excel file (say, c:\Master.xls) that link externally to other files (say, C:\xyz\OtherFile.xls). We need to send (via email) Master.xls to someone for editing (but OtherFile.xls is not send together). When the file is sent back to me, the link to OtherFile.xls changed (instead of C:\xyz\OtherFile.xls, it becomes OtherFile.xls only), thus making all the calculation failed. ... 1 29.09.2006 06:21:36 What will work like hyperlink but Ineed to email this workbook I am doing a large insurance claim in which I am having to hyperlink a copy of a scanned invoice that is saved on my hard drive to show where the numbers came from It works great on my hard drive but will not link after emailing in which I am assuming is because the email dod not pick up the linked docs from my hard drive and email them as well is there a better way ?... 1 28.09.2006 12:55:02 Updating of Downloaded Spreadsheet I regulary download a spreadsheet which has a filename format of Data_Date_Time.xls For example SurveyData_290905_1105.xls Each downloaded file has identical column structure but a variable number of rows. I have another spreadsheet analysis.xls that does all the calculations. I'm trying to work out the best way of being able to download the latest data file and then for the anal... 1 28.09.2006 09:10:25 Populating an excel calendar - eg. 10x tuesday/thursday from date x Hi, I'm a newb on the excel/VB thing and I am trying to set up a class timetable for casual teachers. What I need is someway of typing in some info (days.eg tuesday+thurs, class name, start date, and no of times). Does anyone have any suggestions/code I could play with or links I could check out? Really appreciate your help. Cheers, Verzog ... 1 28.09.2006 09:00:30 Capture RS232 data Hello, I work with a system that prints out receipts on a dedicated little printer whenever there is a transaction. I want to be able to capture the information onto a laptop that I plug in instead of the printer, and end up with it all in an Excel spreadsheet. The printer connects to a multi-pin socket that looks like a COM port. The data comes out (and I don't know what any of this me... 4 27.09.2006 16:28:32 linked cells Hi, On Sheet1 I have cells linked to cells in Sheet2, Sheet3.... (I did Copy and Paste Link). With about 20 sheets in a workbook, it gets difficult to go between Sheet1 and the rest of the sheets. Is there a way, e.g. double click on a linked cell on Sheet1 to activate the sheet (Sheet2, Sheet3 ...) with the source cell on it? Thanks, ... 2 23.09.2006 19:15:02 Automatic Function Result Update when using A VLOOKUP on another F Hi all, I have an excel file A that use a VLOOKUP to retrieve data from another Excel file B. The data retrieved in B file is computed with diffrerent funtions that get data from a database. When I open file A, the data from B is retrieved BUT the functions into B are not recomputed so I retrieve out of data data. Does someone know how to do in order that I get data from file B upd... 4 23.09.2006 16:22:12 Excel and Access link I am using MS Excel to handle my transactions but with my present rate of data, I will reach the limit in terms of number of rows of one spreadsheet, ie. 65,000+, in no time. Is it possible that I use MS Access as my database but processing will be done in Excel? I am not familiar with MS Access that is why I use Excel but did not foresee the rate of population. Or is there a way wh... 3 21.09.2006 03:16:01 Links from websit I would like to create a link form a webpage to a specific worksheet in my excel spreadsheet. Is it possible to link to a specific worksheet or point in excel and how do I do this. Thanx... 1 19.09.2006 05:34:02 links to attachments Hi We run couple of Citrix farms, where on one, the users inserting links to attachments, especially pdf files, adobe acrobat would open up just fine. On the other farm, when a user does that, acrobat opens up then shuts down immediately. This happens very quickly. I got a feeling this is a registry issue, it's only last week that this issue has been raised with us. Mind you, we have ins... 1 18.09.2006 15:51:02 Updating Links Each Month I have 3 spreadsheets which I maintain to track sales. One for each of our branches and one which serves as a master. I've been manually typing the numbers in each sheet but I am sure there is a way that I can enter the numbers once in the master and reference the appropriate cells. The master sheet is quite simple with the entire year on the sheet for each rep. The branch reports consis... 6 12.09.2006 19:58:44 Continous updating of linked spreadsheet I have a master workbook that then links into a shared workbook, open on different workstations, however when the master has a linked cell changed, the shared workbook does not update dymanically, is there a way do to this? Regards Tony.... 2 04.09.2006 17:09:38 Links broken after upgrade Hi, A client has reported the following problem: He works in a corporate enviroment. They have recently upgraded from Office 2000 to 2003. He has a lot of workbooks that pulls data from sheets in other books, typically stored on a network server. When he opens one of his workbooks, he's prompted if he wants to update the links. Even if he clicks "Do not update", all the cells shows just... 2 01.09.2006 12:34:15 pop up calendar - PLEASE HELP Hello everyone... I have the following code on my worksheet to popup the calendar. The calendar worked fine when I was initially putting the code on the worksheet, BUT when I saved and closed my worksheet and re-opened it... the Calendar popped up right on top on the worksheet and I can't change any dates by clicking on it.... (It just stays there - frozen). I only want the Calendar to pop... 1 31.08.2006 21:17:48 Unexpected closure of Excel I have a 23Mb Spreadsheet which has links to various other sheets and PowerPoint Presentations. When I select certain sheets to create a copy, the following occurs 1. Book 1.xls created 2. reading data....... 3. calculating but at 15% complete Excel shuts down with no warning or error message. if 3, 4 or 5 sheets are open which are not connected, they also shut down w/o saving ... 2 31.08.2006 19:09:02 import data problem Hi hope someone can help with this one... I'm tearing my hair out...!! I've got 2 workbooks on a network which I have set up to send information to each other - Data>Import External Data>Import Data Everything seems to work fine when I have the 2 workbooks open on my own PC (I have the data refreshing every 60seconds) but when I open the workbooks up on different PCs the data dos'n... 1 31.08.2006 11:53:44 Table of Contents Sheet in Workbook I have two sheets in my workbook. One has a listing of table headers like: BOBSTABLE01 - Test for Usenet Help (Cell A1, Sheet 1) The second sheet contains the same header followed by details of the file: BOBSTABLE01 - Test for Usenet Help (Cell A6, Sheet 2) FROM TO FIELD NAME 1 1 XXXXXXX 2 26 XXXXX 27 36 XXXXX 37 40 XXXXXXX... 2 31.08.2006 08:47:01 Hyperlink to paste in other location I am creating a sheet with a column of States as hyperlinks. I have them linked to different sheets in the workbook. I want to have the link data paste/appear in a specific location next to the columns. How do I do this? Thanks in advance ... 1 30.08.2006 04:22:46 Links Update Auto? In file F1 I have links on page P4 to page P1 and they update anytime the data on P1 is changed as planned. However, I also have file F2 that is linked to P4 of F1. The problem is that this data on P1 of F2 is only updated when I open the file F2. The entire function of F2 is to be a sole data source for an Access database that is linked to F2 P1. And the access link works fine, acc... 1 29.08.2006 14:58:02 Links in a template? I have a excel template that has a link to a txt file in the same folder. I would like this link to stay 'local' when the template is 'saved as' a XLS file to a different location, but it always refers back to the directory of the original template. Is there a way around this? And is there a way to define a link in the template by the value in a cell? Say when my data is impor... 1 29.08.2006 09:50:04 Excel 2003 losing Linked Cells We have a problem with linked cells. We have a main spreadsheet which links to other spreadsheets, the problem is that occassionally the linked cell refrence is lost and the cells are replace by #ref. Can anyone help please. ... 3 28.08.2006 20:49:32 Is this possible in Excel I wish to create a worksheet with a drop down list of tools which i can pick the tools I need and create a list to give to someone to get ready ,this I can do but what i also want to be able to do is , If I pick tool "A" and their are several other tools assocatated with tool "A" when I pick tool "A" from my drop down list these assocatated tools are automatically picked at the same time and ... 2 26.08.2006 15:26:09 excel lookup matching and value display You can see on the file samplewrapwrep4.zip Worksheet B of B62, I then typed 15254", it col name "yarn count" and the product code you can see is Q921 at cell A62 is same row 62. Worksheet A, you can see F2 is Q921, col name is "product code". Now if i input a value on cell B62 ='15254' and I want it shows on worksheet A - G2 but remember it must match the product code of worksheet... 2 25.08.2006 01:55:01 Maintaining links when copying entire directories I have an excel file that links to several other files in the same directory. Previously, when I made a copy of the entire directory, the links in the new directory would refer to the files in the new directory. However, today when I copy an entire directory, the files in the new directory link to files in the OLD directory. I've never had this happen all the years I've worked with Ex... 2 24.08.2006 10:25:03 Mysterious change to #REF This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C6C636.07DA04A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a five-tab spreadsheet/workbook on which all data entry takes = place on tab 1, other tabs contain look-up tables, instructions, etc and = the final tab is the data storage area. Each tab/sheet is p... 3 24.08.2006 02:04:47 9 Pages: 1  2  3  4  5  6  7  8  9