|
Excel 2000 bad start up
Loaded office 2000 on XP home machine. All programs run OK exept Excel.
On start up A MS error report is created. In the log the system is reported
as Windows NT, not XP Home. HELP...
|
1 |
25.07.2006 00:26:01 |
|
|
how to calculate $1000/year at 5% for 25 years showing each year
I need a formula or some way to figure out how to show an investment of $1000
per year at 5% for 25 years. and I need to show each years interest accrued
and total. HELP!...
|
1 |
24.07.2006 23:58:01 |
|
|
Menu Bar
I'm having the same problem someone else did. While attempting to use the
Customize function on the Tools menu (on the top menu bar), the Tools
dropdown option just disappeared. Now I just have File, Edit, View, Insert,
Format, Data, Window, and Help options.
How can I get this back? It's critical for the types of things I'm doing in
Excel 2003. Help!
--
Boyd...
|
3 |
23.07.2006 23:43:02 |
|
|
Copy/Paste over rides data validation
Hello,
The data validation response i received on my intial posting worked when you
manually key in the same value preventing duplication but when i tried to
copy and paste the same value it ignored data validation and allowed a
duplicate entry. I need something that will worked weather manually keying or
copy and paste to prevent duplicates. Does this require VB or macro use?
Thank...
|
2 |
23.07.2006 02:39:15 |
|
|
how do I insert a formula into Excel and number not disappear?
I am using Excel and I am a novice. I am trying to type my formula in the
formula bar but then the number that I want to place in the cell disappears.
When I place the number in the cell, the formula disappears. Please help....
|
2 |
22.07.2006 08:35:01 |
|
|
how to setup autosave in excel 2007
Hi
Could someone please tell me how to setup excel 2007 for autosave, ie how to
find it to begin with and then how to make adjustments to the time how often
etc ctc
Thanks
Steve...
|
1 |
22.07.2006 08:25:01 |
|
|
Rookie Alert-
Need simple formula for finding 30% of a number...
|
4 |
22.07.2006 08:15:02 |
|
|
how can I have Excel accept date in format dd/mm/yy ?
I set the date format with regional settings "Italy" how ever I still have to
enter date as mm/dd/yy while we are used to write it dd/mm/yy.
Did I did the wrong settings, even if I tried sevral european ones, or is
there something else to do so that I could finally insert a date in a way I
always did it?.
many thanks in advance...
|
4 |
21.07.2006 21:04:01 |
|
|
custom toolbar looses buttons when closed
Hi all, I've crossposted to three groups as I'm not sure of the best
location. Apologies if this breaches protocol.
my custom excel toolbar (office97) with macros linked to 3 buttons worked
fine in Windows NT, but a recent enterprise wide upgrade to XP has resulted
in the buttons on the toolbar dissapearing each time Excel is restarted. I
understand this is because the C:\ drive is lo...
|
3 |
21.07.2006 06:10:35 |
|
|
how to delete duplicate records in a row
Hi. I was browsing the topics in the forum and most of the things I found are
deleting duplicates involve entire rows. My problem is this, I need to delete
duplicate records by row. For instance, in my example below, I want to
elimate the duplicate "20" under column C so that row 1 would only show 4
records (10, 20, 50 and 30). I'd appreciate any assistance anyonoe can
provide.
A ...
|
3 |
21.07.2006 00:39:01 |
|
|
CATCHING DUPLICATE INFORMATION IN DIFFERENT CELLS SAME PROGRAM
I am working in excel and need to have a warning when information previously
keyed is being duplicated in the same colums. Example: column B is always
ticket numbers. I want excel to warn me if while keying in column B I key
the same number in a different cell. I want this restricted to certain
columns not the entire workbook....
|
2 |
20.07.2006 16:21:38 |
|
|
missing data excel 2000 to excel xp
I have created a database in excel 2000. To gather the data from the database
l have used the template wizard. I need to load the database onto my computer
at home which is windows XP. I can open the database from my memory stick but
my list and combo boxes are not displaying. Does anyone know what options l
need to set. I have a macro within the database in which l have set the
security...
|
3 |
19.07.2006 13:17:01 |
|
|
input # on sheet 1, pulls all info for # from sheet 2
I have two sheets in excel. Sheet #2 has info in A1 through Af, 400 items
listed down, all items have a unique number. When I enter that number in
sheet one how do I get it to pull all the info from sheet 2 onto sheet 1?
...
|
2 |
19.07.2006 09:43:17 |
|
|
How do I change the color of the autofiler indicators?
The autofilter indicators (the little black or blue triangles) are difficult
to tell the difference between unfiltered (black) or filtered (blue). Can I
change the default color for the filtered columns to something more
distinctive than the blue color?...
|
3 |
19.07.2006 09:12:59 |
|
|
shortcut: copy cell right down
Is there any short cut to copy just above cell to its bellow cell?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan...
|
2 |
19.07.2006 07:26:01 |
|
|
lock cells for input
There was a command, protecting cells from unwated edit.
I thought it is in options or cells, but I couldn't find.
Do you where is it?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan...
|
2 |
19.07.2006 07:18:02 |
|
|
How do I change the default cell reference from absolute to relati
It is my understanding that cell references, by default, are set up to be all
relative. Somehow I've changed my defaults to have my cell references all be
absolute. What menu setting do I have to change to get the default back to
relative?...
|
4 |
19.07.2006 00:03:34 |
|
|
Excel Footers and Headers
Is there anyway to do one footer and header and have it apply to the entire
workbook. I have 70 sheets I'd like to add the filename, tab and date but
didn't want to have to go into all 70 worksheets to add. I've tried in print
view for the workbook but it only did the sheet it was viewing at the time....
|
4 |
18.07.2006 18:52:01 |
|
|
Enable transfer of payroll data from Quickbooks
Since I'vd upgraded to Excel 2003, I can't send the data from Quickbooks for
Quarterly payroll reporting--Help with Excel settings...
|
1 |
18.07.2006 17:41:02 |
|
|
Excel wont autosave; how can i fix this?
My computer suddenly restarted while a word document and excel sheet were
open and office was set to autosave every 2 minutes so i didnt lose my work,
I found the autosave file for word but there wasnt one for excel. will excel
autosave? and how can i set it up that it will?...
|
4 |
18.07.2006 12:41:07 |
|
|
How do you change default file location for Excel on a network?
When i go into options and change the default file location to the "F" drive
for my storage area, it won't let me do this... What am I doing wrong?...
|
4 |
18.07.2006 06:25:38 |
|
|
find and replace
When you choose "find" in msexcel 2003, you can choose options, and change
from the default "within sheet" to "within workbook". Can you modify excel
to have the default option to be to search w/n workbook?...
|
2 |
17.07.2006 21:21:11 |
|
|
Excel OpenCurrentDatabase fails error 7866
Hi, I have problems with an Excel file that uses OpenCurrentDatabase in a VBA
macro... It fails with Visual Basic error 7866
On some pc the same file works fine, on other I have the problem.
When I've tested it I'm sure there was no other users opening the same
database or excel file.
In the past I solved the same problem changing the macro protection to level
"low" (excel and Access) ...
|
1 |
17.07.2006 14:52:01 |
|
|
EXCEL STATUS BAR
HOW TO CHANGE THE VALUE IN STATUS BAR?...
|
2 |
17.07.2006 13:15:49 |
|
|
XL2003SP2: This workbook contains one or more links that cannot be updated.
How do I get rid of the above error message when I open the workbook?
I have tried unchecking the "Update remote links" and then save the file,
close it out and close out of Excel, then reopen the file only to find that
the file has that optioned checkmarked once again. I want to get rid of
this error message as it's so much of an annoyance, why should I have to
click on it every singl...
|
3 |
17.07.2006 04:50:45 |