| Thread | Last Post | Replies |
|
| Unwanted Link between cells on a sheet, | 15 Oct 2004 23:33 GMT | 2 |
All cells in a column from cell K2 through cell K17 apparently, have a link
to cell K1.
Whatever word or sentence I enter in cell K1 is pick up by any of the cells
below it when I enter the first letter of the word or sentence in one of
|
| Can cells pointed at another not only pick up data but the format? | 15 Oct 2004 22:41 GMT | 1 |
I have a spreadsheet with multiple worksheets. I have one data sheet
feeding the others, but the data format is not displayed in the following
worksheets. Is there something that I am missing, or is it not possible.
I am using Excel 2000.
|
| error: Not enough memory for VLOOKUP using external file | 12 Oct 2004 08:28 GMT | 1 |
we are encountering an error "Not enough memory" when we try to save
Pricing.xlt template file containing the following formula:
=VLOOKUP(B7,[_bpcs_pricing.xls]BPCS!$A1:$E$62050,2,FALSE)
we are using Microsoft Excel 97 SR-2
|
| http link | 12 Oct 2004 08:28 GMT | 3 |
First of all, excuse me for my bad english ... I'm Portuguese :-)
I need to create links from a worksheet to my web shop. I have a column with
the ID numbers (like, A1 = 1066, etc)and i need to have a link like:
http://www.multimediastore.pt/shop/product_info.php?products_id=1066
|
| Would like to retrieve values from an external file using VLOOKUP | 12 Oct 2004 08:28 GMT | 1 |
Is it possible to retrieve a value from an external excel file using Excel
97 SR2?
We have created a pricing.xlt template containing VLOOKUP function that
retrieves information from an external Excel file named _bpcs_pricing.xls
|
| Linking Workbooks? | 12 Oct 2004 08:28 GMT | 1 |
I have the main workbook in one location on server. I need a second workbook in another location that when opened will "show" all data in the main workbook. I have tried the copy and paste special into the new workbook but Excel does not like that. any ideas on an easy way to ...
|
| problem with findlink | 12 Oct 2004 08:28 GMT | 1 |
I've tried to use Bill Manville's Findlink macro, but
having downloaded the zip file, installed it into Excel I
get the message when I use the new menu option under Tools:
The macro 'findlink.xla!FindLinks' cannot be found
|
| Securing the originating document but allowing link access | 07 Oct 2004 08:16 GMT | 1 |
I have linked a second spreadsheet to an originating
spreadsheet and everything works fine, i.e. a master
spreadsheet sharing certain data with subordinate
spreadsheets. However, I need to prevent users opening the
|
| Want to activate links to websites | 05 Oct 2004 21:13 GMT | 3 |
I am importing a lot of columns from text into Excel. One of these
columns is websites. I want these websites to be active so that when
I open this document in Excel, they are "active," I can just click on
them and it will take me to the website. Right now, the only way I
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread