|
sku011.cab
i need this file is there any place i can go to get this file downloaded...
|
2 |
13.03.2006 21:06:16 |
|
|
sku011.cab
i need this file is there any place i can go to get this file downloaded
(sku011.cab)...
|
1 |
12.03.2006 19:39:18 |
|
|
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 |
09.03.2006 19:28:46 |
|
|
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 |
09.03.2006 16:17:48 |
|
|
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 |
06.03.2006 09:56:28 |
|
|
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 |
01.03.2006 07:14:07 |
|
|
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 |
28.02.2006 08:39:29 |
|
|
Formt of Linked cell
Hi I have links in the cells of one worksheet to cells in another worksheet.
I want not only the value of the other cells to be linked, but also the
formatting to be linked. Is there any way to do this?
Thanks....
|
1 |
22.02.2006 11:16:30 |
|
|
Excel Links Update
I have a problem getting my workbooks to update with the most recent
data. For example, workbook A passes data to workbook B, B then passes
data to workbook C. If data is updated in workbook A, workbook C does
not update until workbook B is opened and saved first.
In Office 97 I could open workbook C and the data would update without
opening workbook B first. After our new upgrade to Off...
|
1 |
21.02.2006 13:48:53 |
|
|
Excel Links Problems
My office recently upgraded from Office 97 to 2003. Since doing so our
linked Excel Workbooks have been getting a #REF error when opened. I have
now re-established the links between workbooks (19 in all) and we no longer
get the #REF error message. However, I have now unknowingly created a
hierarchy of linked workbooks: Data or source workbook A; then target
workbooks B; then final T...
|
1 |
20.02.2006 18:10:29 |
|
|
hyperlink base did not save
Using Excel 2003, when we create a new spreadsheet, if we specify the
hyperlink base, it is not saved when the files is closed.
However, we have some files that do save the hyperlink base. They might
have been saved with another version of Excel, I don't know. If these files
are copied or saved-as, the copies also work. On the files that work, the
hyperlink base can be deleted, and lat...
|
2 |
17.02.2006 23:53:26 |
|
|
Change Source / Update Now buttons not available
My problem is that I want to change the source workbook but the Change
source button is not available? The source file updates weekly (one for
Monday, tuesday, etc). Before these files are updated, they are archived
to a different folder but all under the same name (i.e. MON TUE WED
etc.). I want my formulas to compute using the archived files but the
Change Source button is not available! I had ...
|
1 |
16.02.2006 22:33:40 |
|
|
I can view links, but can't delete them
I have an Excel spreadsheet with links to several Excel spreadsheets that
have been deleted. I can view the links by clicking on Edit and Links, but
there is no option to delete them, only update now, open source, and change
source. Any ideas on how I can delete all my links?...
|
5 |
16.02.2006 22:28:46 |
|
|
Change links on moving to CD or another computer
I have a large number of Excel files with links to some common data
files all held in teh same directory.
How do I copy these to a CD in a way that changes the directory
references to reflect the new directory they are in - either on the CD
or when copied to another computer.
Thank you
Rich80105...
|
1 |
16.02.2006 19:21:36 |
|
|
Linking multiple files
-- We have a daily schedule sheet that our power marketers use to enter
their daily power sales and purchases. Each schedule is saved in a separate
file by using the date as the filename, (i.e. m20060101, m20060102,
m20060103… etc).
Is there a way to combine all this data into one file so I can eventually
link it to an ACCESS database for various reports. There are also situati...
|
1 |
10.02.2006 22:26:37 |
|
|
automatic updating of javascript downloadable data
Hi, I want to have an excel office 2003 professional spreadsheet
automatically update its data from a website. In order for me to manually
get the data into the excel spreadsheet, I have to log into the website with
a username and password, then click on a link that opens a popup window which
contains a button I have to click on to download the excel data to my
harddrive. Then I open ...
|
1 |
08.02.2006 05:17:28 |
|
|
can't change field name in query?
I'm using Microsoft Query to bring in some data. I have the query in SQL so i
can do some groupings and count values in one of the fields. My problem is
I'm having difficulty renaming a field, so it comes back with no name at all.
The SQL line is:
SELECT [lots of fields], Count(StudentHistory.Status) AS CountStatus
The count comes back properly, but the changed field name (i.e.,
Coun...
|
5 |
07.02.2006 19:48:37 |
|
|
importing links from access to excel to template
I have a query in access 2003 that I am analyzing with the tools option in
excel. In excel I have created a template which is linked to the imported
excel file. Once the access is in excel, I am opening the template -- which
should bring over the information from the access to excel worksheet. The
information does come forward, but is not in the right location even though
the cells/rows an...
|
2 |
05.02.2006 18:42:32 |
|
|
Linking multiple cells efficiently
I have Excel 2002 and would like to link 2 columns across 2 workbooks. I
know how to link the cells across workbooks one at a time, but I am wondering
if there is way to link columns at time. for example:
In the following example, I could first link 1a to 1b, then 2a to 2b then
3a to 3b. Is there a way for me to select the cells 1a:3a in workbook 1 and
directly link them to cells 1b...
|
1 |
01.02.2006 03:05:27 |
|
|
Creating ODBC link within SELECT statement
Is this possible. To explain myself, here is my situation. I created an
Excel Spreadsheet that uses an ODBC link to a SQL database. In order for
anyone to use this file on their PC, that same ODBC link must be setup. Is
their some code I can use within a Select Statement that will allow me to
bypass having to create an ODBC on everyone's PC?
Thanks.
...
|
3 |
31.01.2006 18:54:49 |
|
|
Query from within Excel
I have a need for some query help and I will try to explain my situation.
Thanks in advance for any help.
I have an Excel spreadsheet that has two different sheets. One one sheet
called "Data" I have created a query that pulls AP Invoices from from a SQL
database. In the results of this query I may have several lines with the
same Company.
Ok here's my question. On my other sheet page...
|
2 |
31.01.2006 06:37:48 |
|
|
worksheet size limit
Why are the cells limited to 256 columns and 65,536 rows? Once a format is
set and then you realize its limits, its too late and too cumbersome to
reorganize the sheets. Are there any future restructuring of these limits to
a more even distrubution of rows and columns (30,000 X 30,000) by Microsoft?
...
|
3 |
30.01.2006 23:48:20 |
|
|
Cell display
I created a workbook that has a summary page with cells that link to cells in
other pages of the workbook. These cells are in date format. When there is
no entry in the cells of the other pages, the summary page cell shows
1/01/1900. I would like the cell on the summary page to be blank if the
linked cell is blank. Does anyone know how to do this?
--
Thanks...
|
3 |
30.01.2006 23:44:58 |
|
|
Access Form In An Access Report (SubForm) Question
I want to cycle through an excel with multiple worksheets, and showing the
first cell of each worksheet (which has drawings in that cell) on a report.
I must change the source path with VBA Code.
So I use a Form with an Unbound Object Frame (OLEUnbound4) Linked to an
excel worksheet, there is a link source path to the excel file and a image
on that Unbound Object Frame (OLEUnbound4). ...
|
1 |
27.01.2006 05:54:01 |
|
|
building a web site
I just got back working on my website. Its taken a long time to finish but I am getting there.
I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing.
Paul ...
|
1 |
27.01.2006 01:26:43 |