Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Mathematica link for Excel All, I am having a problem with Mathematica Link for Excel. When I try to generate some graphics I get -Graphics- back but no graphics is shown. Example sheet: G H 8 Cos[t]+Cos[2t] t 9 Sin[t] 0 10 2 Pi -Graphics- the formula contains =Math("ParametricPlot",G8:G9,I8:I10) I am running Windo... 1 4/12/2006 5:29:54 AM Mathematica link for Excel All, I am having a problem with Mathematica Link for Excel. When I try to generate some graphics I get -Graphics- back but no graphics is shown. Example sheet: G H 8 Cos[t]+Cos[2t] t 9 Sin[t] 0 10 2 Pi -Graphics- the formula contains =Math("ParametricPlot",G8:G9,I8:I10) I am running Windo... 1 4/12/2006 5:29:52 AM Simple link to stored web page I thought this would be easy to do, but so far... no luck. I have created a simple spreadsheet in Excel 2002 that lists the DVD's I have in my collection. I would like to create a link in a cell to a Rotten Tomatoes Web Page that I have downloaded onto my hard drive (for when I don't have access to an internet connection). When I save the web page to it's own folder, and then create the link... 1 4/9/2006 11:46:00 PM info Ho aperto il mio nuovo sito è in fase di costruzione ditemi se vi piace.... www.royaldj.tk Tanti Saluti Dj Royal ... 1 4/8/2006 9:41:36 PM Hyperlinks and AutoFilter When the user uses an autofilter, the hyperlinks (in a separate column) do not sort with the rest of the data. The hyperlinks move, but don't hold with data in the same row. Any ideas on a fix?... 1 4/6/2006 2:56:23 PM Relative Hyperlinks to local files I have a worksheet with cells linked to files contained in the same folder as the spreadsheet file. When I created the hyperlinks, the full path was included. I want to burn the files and spreadsheet to a CD, so want the hyperlinks to be relative, not containing the absolute path of the folder on my hard drive. I understand that in teh absense of a path, the default is relative, but don't ... 4 4/5/2006 5:05:43 AM problem with opening hyperlink in excel 2000 I recently upgraded one computer to excel 2003. When a hyperlink is created in Excel 2003 I can not open it in excel 2000 (on my lap top). As message comes up saying path or file name may have changed. -- I.R. Clubbe... 6 3/15/2006 6:06:37 PM linking one worksheet with another I am trying to create a link between 2 worksheets - i have copied the source data and pasted it to the destination sheet, the data appears but there is not a link - the link is greyed out in the edit toolbar. I have 3 columns of data approx 20 lines that i wish to link to another sheet, sometimes I will need to delete or insert lines in the source data but this is not transfering to the destinat... 2 3/24/2006 9:10:27 AM Advice on how to automate Hello, I have a large organized 'master' workbook that contains certain pricing information on items at various breaking points (based on quantity). I also have a large collection of individual workbooks for each part with detailed information on pricing at specified breaks. Everytime the master workbook is updated, I would have to manually go through and update each individual workbook. D... 1 3/15/2006 7:05:05 PM Copy/Rename a sheet After I've copied an existing sheet, I then rename it, but when I go to print it keeps the original sheets name, not the new name I gave it. How can I change this so it has the heading of the correct name.... 2 3/20/2006 5:36:12 AM Ink Sorry guys. The spam stuff was not my intent. I do oppoligies and won't happen again. I have never been on newsgroups before and not sure how to work them. I hope you guys can forgive a bad choice. Murphey... 1 3/20/2006 12:07:34 PM Duplicate names on copied worksheet Hi, I am using Excel 97 and every now and then when I copy a worksheet in the same workbook to reuse as a new worksheet base, I get an error message: "A formula or sheet you want to copy or move contains the name 'pat', which already exists on the destination worksheet. Do you want to use this version of the name? To use the name defined in the destination sheet, click Yes. To rename the... 1 3/20/2006 11:36:42 AM Linking multiple workbooks I have a scenerio where we want to make 6 regional workbooks that contain customer contact info and other key data. We want to have a "master" book that contains the national data. We would like to find a way to automate this. In summary, we are looking for a method to merge the entire contents of 6 regional workbooks (only one 1 worksheet per book) into one "master" workbook. We are u... 1 3/21/2006 6:11:58 PM macro to fill blank cells Hello, i have to update all cells with zero if it is blank according to a particlular date. In other words, if the date is todays date and the cells are blank, then i need to put zero in each of those cells. i was thinking wheter i can write a macro on it so that i need no do it manually for each and every sheet. can anyone help me out on this. thanks & Regards, sunny. :)... 2 3/24/2006 9:09:12 AM Variable SQL Statements pulling from a cell in Excel I have a situation that I hope someone can give me a good answer to. Please bear with me as I try to explain my needs. My goal is to have an Excel spreadsheet that pulls from a SQL database and the the query pulls from a variable in the Excel sheet. For example let's say I am pulling Sales Orders from SQL, let's also simply assume the record has two fields Year and SOno. Under a si... 9 3/28/2006 12:21:17 PM Cannot connect to SQL 2000 AS SP 3 cube from Excel 2000 I have a user who is using Excel 2000 SP 3 to connect to cubes created in SQL 2000 AS SP 3. The user does have permissions to browse to the cube. Originally I could not even connect to the cube itself, nor did I have the OLAP 8.0 provider. I tried all the Office updates, and per a newsgropu tip, I installed the pivot table service (SQL2000 CD \msolap\install\PTS\ptslite.exe). I ca... 2 3/28/2006 8:55:10 PM how to do a web query on an web browser on an user form using macros How to do a web query on an internet explorer object using macros how to do a web query on an web browser on an user form using macros. Please respond to this as i am stuck up on my project. thanks & Regards Sunny -- Message posted via http://www.officekb.com... 1 3/28/2006 12:47:28 PM How to make "This workbook contains links to other data sources" appear? Hello How to make "Microsoft Excel This workbook contains links to other data sources To update all linked information, click Yes. To keep the existing information, click No." pop up or appear on the Task bar after clicking "Open Link" in "Linked Worksheet Object" in a context menu of a linked object in Word 2003 sp2? The window appear only after clicking an Excel button in the Task bar. ... 1 3/29/2006 2:39:49 PM Linking Sheets I have 3 sheets which I am constantly adding to and then sorting in date order as cars are rented- they have the same headings but different car types. Is there a way of linking all 3 sheets into a single a sheet which would then be sorted in date order. Working in 2000 Thanks... 5 2/28/2006 8:39:29 AM EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>YOU COULD BE EARNING OVER $3K A DAY , $100K A MONTH.INCOME. CHECK IT OUT. Investment is only $5. 99cents a month.</P> <P><A href="http://www.vosar.net">www.vosar.net</A></P> <P>Tel: 775-333-11... 1 3/1/2006 7:14:07 AM network problem We have a document called Beaufort.xls. This documents is on our network and contains various lists (like currency details or ship names etc). These list are used in various cells of various templates I have created. Normally we first open the file Beaufort.xls and thereafter one of the templates and that just works fine. Recently a new colleague joined. However when she opens the ... 1 3/6/2006 9:56:28 AM Help with linking I am using excel 2003. I have been asked to help create a March Madness excel worksheet to track our company pool. I would like to have a master file and a Template file to send out to my fellow employees. I have a tab labeled "Template" that will be renamed to that person's last name in the template file. The problem happens when I copy that "Last Name" tab into the master file. I would... 1 3/9/2006 4:17:48 PM answer to odd results when comparing hyperlink addresses I have written a VBA macro to check certain spreadsheets for valid syntax. Certain cells are supposed to have hyperlinks, whose addresses are related to the value of the cell, which in the case of cells with hyperlinks is also the TextToDisplay value. I am currently adding a check for the hyperlinks. Most of the time, the checking was fine, but I was getting a message for some of the ... 1 3/9/2006 7:28:46 PM sku011.cab i need this file is there any place i can go to get this file downloaded (sku011.cab)... 1 3/12/2006 7:39:18 PM sku011.cab i need this file is there any place i can go to get this file downloaded... 2 3/13/2006 9:06:16 PM 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13