|
Why do I have a split screen on a saved Excel file?
...
|
2 |
27.09.2006 11:21:55 |
|
|
Restore missing Excel icons?
I have Microsoft Office Pro 2000, SP-3. I have several Excel spreadsheets
stored on my desktop. Today all my icons disappeared. The files seem intact
and the outline of the original icon remains, but it is blacked out. What is
causing this and how do I fix it? Nothing has been installed or modified
lately, and I can't seem to bring up an option in the properties list to
change the i...
|
3 |
27.09.2006 11:16:02 |
|
|
extracting info related to maching entries
I have a table with various fields of information in each cell.
one column has a list of names, these are repeated randomly throughout the
column.
i want to creat a chart from information relating to each name. So I need to
search through the list and wherever the name entry equals for example, aaa
in column b, i need the related info for each maching name from column A.
So if i have:
...
|
4 |
27.09.2006 11:13:01 |
|
|
change a vertical list of numbers to horizontal list from 1 cell
Hi
I have a vertical list of 6 digit codes and wish to copy turn them into a
horizontal list in a single cell. Each code is prefixed by '.
thanks...
|
4 |
27.09.2006 11:11:02 |
|
|
Problem with MS Query in Excel
Not sure where to post this question. but here goes...
The problem that I have has to do with using Microsoft Query (launched in MS
Excel)with a "Microsoft ODBC for ORACLE" connection.
Whereas I can connect to this using SQLPLUS, I cannot connect to it from
Excel...Data ...Import Data....New Database Query.
I get an error message box which contains a yellow Exclamation mark icon as
we...
|
1 |
27.09.2006 11:05:01 |
|
|
Lost of data in a sahre file after several saves!!!
Hi I hope someone can help me..I got an excel file which is a shared
file and share across with staff to update and revise some info on it.
But lately I found some data bn revised there suddenly gone once I hit
save, it seems it gone back to maybe 3 or 4 "Saves" before. This
happens more frequent than ever after I have put in a Macros script
there.
Urgnetly await your advice..
...
|
1 |
27.09.2006 08:53:54 |
|
|
Set up costing sheet for multiple component recipe.
Hi,
We are a small business and do our costings on an excel spreadsheet. We have
a list of ingredients with costs and these are matched up with quantity to
work out total costs. We have 200+ recipes and this is very messy -
especially if ingredient prices change. If we use a data link to a single
ingredient cost file, I would think this will also be cumbersome? Is there an
easier way an...
|
2 |
27.09.2006 08:34:02 |
|
|
Replace Vlookup with a macro
I have a huge excel sheet being shared over the network the problem is that
when i run vlookup and save the file the file size goes very big. also the
data is really huge in these and its really inconvenient to run vlookup again
and again. i want to automate the process that when i open the workbook i
just run the macro and its done.
the current vlookup goes in cell c of worksheet 1 an...
|
2 |
27.09.2006 08:32:12 |
|
|
Remove Numeric from a Text String - Help?
Hi,
Can anyone helps me with a problem I have got?
I have a column of cells with data in e.g.
123 apple
4390 banana
yellow 56973
I need to remove the numerics and leave the text - how can i do this easily?
Thanks,...
|
10 |
27.09.2006 08:25:05 |
|
|
Missing the security tab
I used to have a tab labeled security when I clicked on properties of any
document. It has disappeared. I have disabled the simple sharing and still
no luck....
|
2 |
27.09.2006 07:53:59 |
|
|
Conditional Formatting across many cells with a mobile comparison
My description was probably more confusion than helpful but here we go...
C4 has a hard coded value in it.
The range C8:V8 has values created due to a formula (say something like D8
has =SUM(C8,D7) and E8 has =SUM(D8,E7).
Now I've got another formula value in C12:V12, that I want used in the
comparison.
I highlight my range C8:V8 with C8 being the active cell. The formula I put
in...
|
3 |
27.09.2006 05:37:58 |
|
|
Print Page Numbers
Is it possible to create a formula that returns the page number relating to a
particular cell?
For example, I have a print range set up that has multiple pages and I would
like to determine what page number a particlar cell, say "F123", will appear
on when it is printed.
Hope that makes sense.
THanks,Kaval
...
|
3 |
27.09.2006 05:15:02 |
|
|
Formatting a Cell as "Time"
Hi...
I'd like to format a cell as "Time". I want to use the 24 hour Timing
system, but When I enter the time: 24:00, I don't want it to apear like
this: 0:00. Is there any possible way to do this....
|
3 |
27.09.2006 05:15:01 |
|
|
Would I use an "If and" statement?
I have a table as shown.
Column A Column B
Y
???? Y
???? Y
???? Y
I need a formula says if Column B = Y, then return 1 only if the sum of all
previous cells in column A is less than 25. if greater than 25, then 2. And
if all of 1 and 2 is great...
|
3 |
27.09.2006 03:36:01 |
|
|
Why won't my text fully display with word-wrap and merged cells?
I am using Excel 2000. I have a merged cell (6 cells wide and 1 deep) with a
paragraph of text with word wrap enabled. After about 7 or 8 lines of text
the text does not word wrap anymore. It would be about 2 more lines.
Any ideas?...
|
9 |
27.09.2006 03:09:16 |
|
|
Getting the sum of the same cell in defferent exel sheets.
I am working on a big excel sheet, and I am kinda new at it. How can I get a
sum of the values on 45 different excel sheets? I can only get the sum of
about 15 sheets for so before it says that my formulat is too long. Here is
an example of the formula: =SUM('Service Invoice (45)'!D29+'Service Invoice
(44)'!D29)
I need to get the sum of cell D29 from sheets 1-45.
thanks for your help...
|
3 |
27.09.2006 02:54:29 |
|
|
pivot table field sorting!
hi
I) i am having dates in COL A of my table.
when i go in for pivot table for that table
i can't sort the dates in ascending order
eventhough the ascending order option
is selected.
instead the dates are in the order say
01/06/2006
01/07/2006
01/08/2006
02/06/2006
02/07/2006
02/08/2006...
|
1 |
27.09.2006 02:51:14 |
|
|
Pivot Table - Drill down to source and update
Is there a way to drill down on a cell of a pivot table and update or change
the underlying source data from the pivot report? I'm afraid that the users
will have too much trouble understanding the data in a matrix or table format.
The Pivot Table report is being used as a budget report and I would need the
user to be able to change or adjust some of the fields in the amount area.
The ...
|
2 |
27.09.2006 02:50:01 |
|
|
Data Entry problem
Hi all,
When I try to type in "1:500" without any formula in it plain text excel
return a value of "0.388888889". Why is that and what is the colon mean. I
try to work it out i got no clue how excel got that value.
Thanks in advance
Jason...
|
3 |
27.09.2006 02:35:46 |
|
|
Data entry
When my boss tries to type a quotation mark, it does not appear nor does the
cursor advance until you press the spacebar. How can I correct this?...
|
4 |
27.09.2006 01:47:01 |
|
|
Under Page Setup the page option of Ledger - for Office XP
Have someone using Excel 2002, needs to print an Excel file on Ledger size
paper. However, they do not have this choice under page setup. Reinstalled
Office using complete install - did not add this feature. Installed SP3 for
Office XP, and all the updates - still no Ledger choice??
Checked on my system, running Office 2003, and I do not have this feature
either.
However, I have syste...
|
3 |
27.09.2006 01:46:02 |
|
|
excel generated polynomial equation is wrong
fitting a trendline to data and the polynomial equation it spits out is
obviously wrong. Any ideas? thanks...
|
10 |
27.09.2006 01:45:51 |
|
|
How can I do a mail merge w/ Excel contacts into a Word document?
I have 200 contacts in an excel spreadsheet. I want to type a letter in Word
so that each letter will be written to a different contact. Thanks in
advance for any suggestions....
|
2 |
27.09.2006 01:45:10 |
|
|
where can i find the auto fill options?
plz tell me where can i find the atuo fill options and also where is the
toggle total row
thank you ...
|
2 |
27.09.2006 01:43:10 |
|
|
Cannot remove read only attribute
A frequently used .xls file suddenly could not be modified because it was
labelled 'read-only'. The read only attribute can be removed but when the
file is closed and re-opened the read only has returned. Data cannot be
saved to the original file on closing. Can anyone please advise how to
remove the 'read only' attribute permanently.
...
|
3 |
26.09.2006 23:37:16 |