| Thread | Last Post | Replies |
|
| Help: Compare two columns | 29 Oct 2003 23:50 GMT | 1 |
I have two coloumns of numbers, which i need to compare. The Excel document should come out with 3310 as a result in coloumn 3. Can someone help me? example:
|
| Why VBA inserted link won't work???? | 29 Oct 2003 18:16 GMT | 2 |
Why does this not work. If Left(WsMas.Range("MasLoanProduct").Value, 4) = "Busi" Or Left(WsMas.Range("MasLoanProduct").Value, 4) = "Coml" Then ActiveSheet.Hperlinks.Add _
|
| Excel 2000 Publishing Web via FTP | 29 Oct 2003 09:01 GMT | 1 |
I am trying to created a web page in Excel (2000) and publish on a Host web site (UNIX). When I publish the Excel sheet locally on my machine it all works fine - I can see and interact with the sheet as advertised by
|
| Linking through multiple sheets not updating... | 28 Oct 2003 10:23 GMT | 1 |
I know this has been mentioned, but I can't find my exact situation in the previous few days posts. I have 5 excel documents. DocA.xls, DocB.xls, DocC.xls, DocD.xls, DocE.xls. My accounting department has a very elaborate reporting/calculating string
|
| Problem with cut and pasting a link | 27 Oct 2003 07:51 GMT | 1 |
I know this sounds simple but I am having a problem with cut and paste in Excel 2003. When I go to Pricewatch.com, copy and paste a group of cells, for example the lowest price on a specific CPU to an Excel spreadsheet, the column which has the price with shipping only shows with ...
|
| Automatic Link Queston on Open | 26 Oct 2003 11:02 GMT | 2 |
I have about 4000 spreadsheets, all with links to a single spreadsheet to pick up some rate fields. I am now trying to convert those Spreadsheets to a FoxPro database. I can open each of the spreadsheets from within FoxPro, but when I open each one I get the message concerning ...
|
| How do you find the Link | 24 Oct 2003 01:00 GMT | 2 |
Someone in our office has opened an Excel sheet & the following message came up 'The workbook you opened contains automatic links to information in another workbook. Do you want this workbook with changes made to the other workbook? To update all linked information, click, Yes.
|
| Converting to MS Access | 20 Oct 2003 12:25 GMT | 2 |
I'm joyfully working my way through the MOUS Excel course and have reached the section on coverting a spreadsheet into an Access Database. However, when I click convert to database, then select new database, Access open but the
|
| link viewer problem | 19 Oct 2003 22:10 GMT | 2 |
First off - I am running Excel 2000. I have a workbook that has several sheets. On one sheet when I click an icon that is linked to a file on my hard drive it opens the right viewer (ACDSee). On another sheet it opens the wrong viewer(Paint Shop Pro). I
|
| LINK TO OPEN EXCEL FILE ! | 19 Oct 2003 03:28 GMT | 1 |
I send an Excel Workbook as a Microsoft Outlook e-mail attachment to some folks on my network. However the attached file sometimes get so huge, so I have decided to place the Workbook in a network folder accessible to everybody.
|
| links to another workbook page on someone else's computer | 18 Oct 2003 14:24 GMT | 1 |
right now I link one of my pages to another guy's on a differernt computer like this: ='[5130 fees.xls]Sheet1'!$A$40 I am just using A-D.
|
| want to know about the excel | 18 Oct 2003 10:41 GMT | 1 |
Hi I want to know about excel
|
| Links | 16 Oct 2003 14:29 GMT | 1 |
I'm experiencing problems with a worksheet also. It has links to around 20 other spreadsheets. When I open it and choose to update the data from the linked spreadsheets it's taking literally 8 minutes to open. I've noticed also
|
| Passing Variables into Links | 15 Oct 2003 10:20 GMT | 2 |
I have written VB code that, on the press of a pushbutton, creates new sheets from a template, it also puts the sheet name in cell A1 of the new sheet. I also have a Summary Sheet, and when I press the add
|
| link multiple cells from other workbook on another machine on network | 13 Oct 2003 16:58 GMT | 2 |
I have an entire page I updated from a workbook in another page on another computer on the network. I've figured out how to have it update an "image", but the the cells. I know how to link individual cells, but not a group.
|