Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   Change Source DOES NOT WORK! - Help!! I see questions about this all over this group, but no answers. When I goto Edit Links, the Change Source button is greyed out. It was working just yesterday!?? What is the reason for this? ... 2 22.04.2006 03:01:05 INDIRECT Function Hi! is it possible to return this kind of string from the indirect function (to use in a LOOKUP function): 'VARIABLE'!B$13:B$46 where VARIABLE is in the cell A1, and gives me the worksheet to lookup the values. Thanks in advance... 3 26.04.2006 01:34:01 Excel function button in spreadsheet Sorry, not very efficient in Excel, but have the following problem : When clicking on a function button on an existing excel sheet, it tells me "file could not be found, check the spelling of the file name, and verify that the file location is correct... The file name it gives me is an older version of the same file with a different name, how can I change this or remove this error... ... 2 25.04.2006 18:33:01 Have excel "cell" launch PDF viewer for stored file I have I am trying to find how do I make a cell so as to when I click on it, It automatically launches a stored PDF file that I have in another directory. Hyperlink does not seem to be working?? -- Red... 2 25.04.2006 15:05:53 Make Money From Google Google AdSense is a fast and easy way for website publishers of all sizes to display relevant, unobtrusive Google ads on their website's content pages and earn money AdSense for search results pages use Google's search to provide relevant results, and the search results pages are customizable to fit with your site's theme https://www.google.com/adsense/?ai=BRRgZ9XRNRM... 1 25.04.2006 06:35:19 Links not working Hello Everyone, I have a user who is running Excel 2003. He has a sheet that is nothing but hyper links and notes about what those links are. When a doc is linked and the document saved the link is no longer working. Here is what the link looks like before and after save. P:\P05502\05201-0000\ENGINEERING\ACEP_5201_Final.pdf .../../M2M/m2mdata01/PROJECTS/P05502/05201-0000/ENGINEERING... 4 21.04.2006 23:31:58 for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 16.04.2006 13:33:18 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 12.04.2006 05:29:54 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 12.04.2006 05:29:52 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 09.04.2006 23:46:00 info Ho aperto il mio nuovo sito è in fase di costruzione ditemi se vi piace.... www.royaldj.tk Tanti Saluti Dj Royal ... 1 08.04.2006 21:41:36 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 06.04.2006 14:56:23 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 05.04.2006 05:05:43 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 29.03.2006 14:39:49 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 28.03.2006 20:55:10 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 28.03.2006 12:47:28 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 28.03.2006 12:21:17 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 24.03.2006 09:10:27 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 24.03.2006 09:09:12 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 21.03.2006 18:11:58 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 20.03.2006 12:07:34 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 20.03.2006 11:36:42 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 20.03.2006 05:36:12 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 15.03.2006 19:05:05 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 15.03.2006 18:06:37 9 Pages: 1  2  3  4  5  6  7  8  9