| Thread | Last Post | Replies |
|
| Querying Info inside excel | 29 Jun 2006 23:19 GMT | 2 |
I want to query information within my excel workbook. This information has been queried externally then a couple of calculated columns have been added that include logic that MS query doesn't support. I then want to query this info. I have tried formulas to pull from these
|
| Dead links retreiving data? | 26 Jun 2006 22:08 GMT | 1 |
I have a cell linked to a file that no longer exists. After this file was deleted, I expected to see "#REF" in the cell. (I always update links when opening files.) However, the cell contained the data from the last time the link was valid. Any idea why a link to a file that
|
| Linking Excel to Powerpoint across the net? | 21 Jun 2006 23:40 GMT | 1 |
Many times I've object linked an Excel file to a Powerpoint presentation. Using a third party add-on, you can then cause the Powerpoint file to update every time it cycles through. Would it be possible to reach out across the net to a text file saved on a
|
| Hyperlinks do not work on local machine. | 19 Jun 2006 23:11 GMT | 7 |
I have a folder with pictures and another folder with Excell spreadsheet in which I have hyperlinks defined to the pictures in the pictures folder. I am using Office 2003. I am experiencing a very strange behaviour: a) I can open my Excell file from two other computers on my ...
|
| Condidtional formatting question | 19 Jun 2006 21:50 GMT | 1 |
Can someone help me please? I use a flowchart that shows numbers either in black (meets minimum standards) or red (does not meet minimum standards). Because I have formulas in every cell through the second week of September, the cells for future weeks show 0.00%. Can someone
|
| How do I get around the 255 char limit? | 13 Jun 2006 13:25 GMT | 3 |
I am linking a master spreadsheet to numerous spreadsheets. I a pulling in text back to the master spreadsheet. I know that excel ha a 255 character limit for linked cells. I noticed however that when initially establish the link I can pull in 700+ characters. I hav
|
| Broken ODBC Connection | 12 Jun 2006 23:47 GMT | 1 |
I am not sure if this is the correct location for this question but here it goes. I have a user with several spreadsheets that update data from an odbc connection. The odbc connections are pointing to ASG Safari InfoServer (not
|
| Linked workbook data suddenly not found | 07 Jun 2006 04:09 GMT | 2 |
Using Excel 97, Win 98/2000/XP. We have a number of linked workbooks that reside on a win 2K server. To the best of my knowledge, they seemed to work fine until Monday. Now suddenly, everytime one of the calling workbooks is opened and links updated, we get the File Not Found ...
|
| Links in 2003 | 03 Jun 2006 11:26 GMT | 2 |
I ahve a spreadsheet, when I open it in Excel 2000 and click do not update the sheet is fine. But when I do the same thing in Excell 2003 all the figures are replaced with #Value. Is there a setting I need to change so that the sheet will open in 2003 just as it does in 2000.
|
| Links not Updating | 01 Jun 2006 15:09 GMT | 2 |
Hello Excel Mavens, I have worksheet linked to another workbook. I have an equation that pulls data from that linked workbook. When I open the workbook, the data does not get updated and I get the #VALUE
|