|
user cannot access his share workbook after opening network path.
...
|
1 |
26.09.2006 15:48:01 |
|
|
How do I get MS - Technical Analysis functions
Hi everyone,
How do I get MS Technical Analysis functions? They are 146 ones.....
Thanks,
Mike
...
|
5 |
26.09.2006 16:03:20 |
|
|
#### In Excel spreadsheet after Export from Crystal
We are running a report in Crystal and exporting the results into Excel. "0"
data in columns is displaying in Excel as "#####".
Can anyone explain why "0"s are not displaying in this exported report out
of Crystal to Excel???
Any help would be greatly appreciated.
Thanks!
wnfisba...
|
6 |
26.09.2006 15:41:02 |
|
|
formula for 55% of a cell reference cannot exceed 156?
I am trying to set up a formula in Excel 2000 to determine paycheck
deductions.
A+B=C
55% of C cannot exceed $156.00 If it does exceed $156.00, I would like the
cell to read $156.00
Thanks for any help!...
|
5 |
26.09.2006 15:40:11 |
|
|
SQL for Oracle
I used Microsoft Excel Query to create a query that looks up an Oracle
database and of course brings results back to the spreadsheet based off the
fields from the tables and criteria I select.
Basically I have 3 tables joined by 3 different key fields.
The criteria is where I run into problems. And I'm thinking at this point
that it may just be that Excel can't handle the criteria brea...
|
3 |
26.09.2006 15:28:02 |
|
|
Duplex printing an Excel Spreadsheet
Is there a way to reverse my margin settings when duplex printing a landscape
spreadsheet so that the wider margin at the top of the first page, shows up
at the bottom of the second page, so that when I punch holes to put it in a
binder, I don't cut into data on the spreadsheet.
--
Matilda...
|
1 |
26.09.2006 15:11:02 |
|
|
How to import appt to outlook calendar from excel?
i would like to set up some sort of format for an appointment schedule in
excel that can be imported to my outlook calendar, is that possible?...
|
1 |
26.09.2006 15:04:02 |
|
|
Group Box
Is it possible to change the format of a group box that I use to group
several radio buttons?
I need to change the line colour of the group box to white.
Thanks...
|
4 |
26.09.2006 15:03:02 |
|
|
Problem with Personal.xls
Windows XP Pro SP2
Excel 2002 SP3
For some reason Personal.xls isn't opening with Excel. The file exists, and
it's located here:
C:\Documents and Settings\My User Account\Application Data\Microsoft\Excel
Any ideas why or why not?
-gk-
...
|
4 |
26.09.2006 14:55:31 |
|
|
##### in 0 columns in Export from Crystal
We are running a report in Crystal and exporting the results into Excel. "0"
data in columns is displaying in Excel as "#####".
Can anyone explain why "0"s are not displaying in this exported report out
of Crystal to Excel???
Any help would be greatly appreciated.
Thanks!
wnfisba...
|
1 |
26.09.2006 14:44:02 |
|
|
Page Break Preview
Is there any way to remove blank pages that are revealed in the page break
preview? Resetting print area will get rid of some at the end, but I need to
remove dozens from the middle of documents. Is there a way to do this with a
macro? Thanks!...
|
5 |
26.09.2006 14:40:02 |
|
|
No RETURN() or HALT() function found on macro sheet
Hi,
I have a excel sheet that has Excel4 macros. When I open then using
Excel2000 on WinXP I get the following message
"No RETURN() or HALT() function found on macro sheet".
I dont have any add-ins enabled.
Any suggestions would be helpful.
Thanks in Advance
Arun
...
|
4 |
26.09.2006 14:35:01 |
|
|
Excel data breakout
I receive this file that has mulitple order numbers populated in one row. I
need each order number to be on a seperate row. Is there a formula that I
can do to make this happen?
Thanks in advance....
|
3 |
26.09.2006 14:28:05 |
|
|
On Error Resume Next (when next statement is Do Loop ...)
2003
If the next code-line after On Error Resume Next is a Do .... Loop,
is the next "statement" the entire Loop or the first code-line
in the Do .... Loop?
...
|
3 |
26.09.2006 14:26:57 |
|
|
Locking Controls
Does anyone have any experience with how ActiveX controls work with filtering
and sorting?
I have check boxes that behave when data is filtered, staying in their
corresponding row, but stay put when data is sorted. When clicked after
sorting, the checkboxes update conditions on completely different rows from
where they should be.
I do have the option for each control set to "move bu...
|
1 |
26.09.2006 13:57:02 |
|
|
Finding a valid cell in a row
I have a spreadsheet with rows of employees and columns of months in the year
for five years. Each month is actually three columns "Salary", "Hours", "%".
There is only an entry when a salary changes. I need to be at one "%" and
look back down the row to find the previous salary so that the percentage
increase can be calculated. How do I find that previous salary. You can
assume the hou...
|
2 |
26.09.2006 13:48:27 |
|
|
Graphing question
Hi there,
I have a graph with two sets of data on two axis.
Can anyone tell me how you swap the axis scales from the left to the
right and right to the left?
What I mean is that I have dollars on the left X verticle axis and
quantity on the right X verticle axis and I just want the quantity axis
on the left and dollars on the right.
Any help would be greatly appreciated.
Thanks
...
|
2 |
26.09.2006 13:40:18 |
|
|
Anyone heard of this company?
Hello
Can anyone tell me if this company is serious?
http://www.paidsurveyscom.info/free - It's taken me ages to find a
company that has no signup costs, 99% of them charge a start up fee.
They pay you to participate and complete online surveys which can earn
you up to $25 per survey. I don't have much money at the moment thats
why i am looking for another income, I've heard about this sort of...
|
3 |
26.09.2006 13:35:02 |
|
|
logarithmic x-axis with a maximum between 100 and 1000
I have office 2000, Excel. I would like to do a diagram with a logarithmic
x-axis with a maximum between 100 and 1000. Is that possible or do I have to
select an axis maximum that are 10x? ...
|
3 |
26.09.2006 13:28:25 |
|
|
Using List Drop Boxes in Excel
I am trying to tie a list drop box into another list drop box... ie: column
1 has a list of vendors. Column 2 is another drop box listing of parts
determined from which vendor is chosen in column 1. I Have no problem
setting up the list boxes just haven't figured out how to tie the two
together. I appreciate any help....
|
2 |
26.09.2006 13:09:02 |
|
|
Subtotal Averages
I'm have a problem explaining differences in avegages in a workbook created
in Excel 2003
If I use sub totals from the data menu I get the following 4 results using
the SUBTOTAL(1, xx:xx) and SUBTOTAL(101,xx:xx):
99.38
98.17
97.26
98.06
But if I use the the standard average formula, or I sum the range and divide
by a count of cells having values I get the following results:
Av...
|
6 |
26.09.2006 13:04:18 |
|
|
Dynamic chart
Hello Experts ..
1. I have a worksheet, Col 1 Year, Col 2 Target, Col3 Actual data of a
products (separate sheet for each product)
2. Data from external DB is populated in Excel.
3. Excel is used to generate the trend chart and bar charts etc.
4. Since the source data (number of rows change in excel) the graph also
changes every time(Number of rows used for chart might increase or decrea...
|
2 |
26.09.2006 13:02:02 |
|
|
Some Excel spreadsheet cells have a red star on the left side of the cell
Hi
A few cells in a spreadsheet (that is being used as an address book)
have a single red star each on the left side of the cell.
I cannot delete these red starts. If I copy the cell, the new cell also
has the red star.
I am using Excel 2002.
Can anyone advise why these red stars are appearing in some of the
cells?
Thanks
Bob
...
|
2 |
26.09.2006 12:50:01 |
|
|
K-mean clustering
Is there any way to do K-mean clustering in Excel?
I know it's possible to do that in Matlab or SPSS but my company doesn't
have these softwares but MS Office....
|
2 |
26.09.2006 12:31:02 |
|
|
excel read only deactivate
my excel file is read only, how do I deactivate to save to CD please...
|
2 |
26.09.2006 12:05:01 |