|
How do I autosave a unique Excel file in the file format 03F67000
We have an Excel file that saves a unique copy of the data each time it
closes. This leaves an audit trail of changes over time. The save happens
automatically and creates a file in the format of "03F67000". How can I make
this happen with new files I create ?...
|
2 |
14.06.2006 22:11:13 |
|
|
copy a function to a whole column
I am entering a figure in column A, i want column B to automatically work out
the vat element of the figure in column A. Then i want column c to add the 2
figures together and display the answer. No problem i can write the formulae
but i want it to apply to every row on the worksheet (and there could be
thousands) and do not want to write it for every one. Ive tried to copy and
paste but...
|
2 |
14.06.2006 20:17:38 |
|
|
Please help Gray excel view
I have installed excel 2003 & mic works 8, When I open my mic works 8 excel
got a error came outs and said, "out of momery, works cannot update the
screen fonts properly. Try closing other open documents or applications."
After I click ok the excel cames out, u can read the tools bar but the whole
excel is gray, u can't type or C the column below. can some one help me pls.
When I use ...
|
1 |
18.06.2006 16:31:01 |
|
|
Tracking system of health clinic
What is the easiest way to set up a tracking system for patient demographics
(name, sex, race etc.) and service codes/category (dental, Psych/SW
assessment, immunization etc.) for a small adolescent health clinic?...
|
1 |
19.06.2006 18:16:01 |
|
|
Reset should give a warning before resetting custom colors.
I just spent 30 minutes customizing colors and accidentally hit reset, losing
my color choices. This is a bad feature!!!!!!!!!!
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the sug...
|
1 |
18.06.2006 00:10:02 |
|
|
How do I remove the email header an Excel toolbar?
This morning the email header (to, from, subject, intro) suddenly appeared in
one of my most-used Excel spread sheets. It takes up a lot of screen space,
and I don't want it there. Neither View, Customize, or Options does anything
to help, though when the Customize dialog box is open, the email header
vanishes only to reappear when I close the box....
|
3 |
17.06.2006 01:05:01 |
|
|
opens in safe mode
Re-installed Office 2003 -Student/Teacher - Excel opens in Safe Mode -
distorts Internet Web Page Display to Safe Mode when I try to search for a
solution....
|
3 |
17.06.2006 00:38:09 |
|
|
remove header and footer on first page
...
|
1 |
16.06.2006 15:42:02 |
|
|
graph: thicker line for datum axis
In my graph, x-axis is in the middle as I have some negative y values. It is
hard to distiguish x-axis from other horizontal lines (they are all with same
thickness).
Is it possible to make only one line (x-axis line) thicker than others to be
recognized?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan...
|
1 |
16.06.2006 07:11:02 |
|
|
How do I set an autosave in Excel 2007
I am trying the Beta version of Office 2007 and wanted to know if there was
an autosave feature in Excel - Office 2003 did not have this and that was
very annoying!...
|
11 |
15.06.2006 15:00:02 |
|
|
date sorting troubles
I have a simple spreadsheet with the date column formatted as (June 13, 2006)
and I am having trouble with the sorting. I have tried various tips via
searching, but to no avail. Could someone help me with this. If you need
more information, Ill give it to you. Thank You...
|
6 |
14.06.2006 21:13:14 |
|
|
How do I have my watch window appear on the Excel 2003 tool bar?
I noticed that the watch window no longer is appearing on Excel 2003 toolbar.
Is there a way that I can set this on my toolbar again?...
|
2 |
14.06.2006 18:54:06 |
|
|
why won't excel recognise times
my 2003 stable book says that when I autofill with a time, such as 11.30am,
the am should change to AM confirming its recognising the data as a time. My
excel 2003 won't do this. Why? And what do I need to do to change it? Only
recently updated from office pro 97....
|
3 |
14.06.2006 12:18:02 |
|
|
Dive by Zero Error
I have a spreadsheet that divides 12 cells by another. The problem is
the cells do not always contain data. Is there any way to remove the
#DIV/0! message that comes up? It does not look too professional.
Thanks,
...
|
7 |
14.06.2006 00:18:11 |
|
|
how to set default page print margins in excel?
Excel print default margins are to wide. I am try to change the default
print margins set by the excel program so that I don't have to reset margins
every time I setup a new spreadsheet...
|
2 |
13.06.2006 19:51:19 |
|
|
Show last edited by
Is there a way to see who edited an excel file last? If you use windows
explorer and look at the properties of an excel file you can see the
last modified date you can also see who the original author is. I
would like to see who made the last modifications.
--
Dave H...
|
3 |
13.06.2006 15:13:38 |
|
|
just downloaded excel viewer and cant open it?
I just downloaded excel viewer and cant open it. Everytime I try, box pops up
asking for file name.. which i did put in exel. doesnt work. What am I doing
wrong?
Kim ...
|
1 |
12.06.2006 18:24:02 |
|
|
Theres no toolbars, no drop-down menus when I open Excel
All I get when i open an excel file or excel itself is a blue bar at the top
theres no toolbars or File, Edit etc
Its office 2003 and I've tried to reload it but that didn't help, Word has
all its toolbars and it worked fine yesterday
I've tried to find the XBL file but the search can't find it
Please Help
...
|
3 |
12.06.2006 11:25:02 |
|
|
What's the best way to do this?
I have a table with lots of data( department number, name, manager, etc.) I
also have a data-request form I want to print off for all of those
departments. What's the best way to transfer all that data to the forms and
print off one for each deparmtment?
...
|
3 |
11.06.2006 22:51:01 |
|
|
Box Plots
How do I draw boxplot using excel?...
|
2 |
10.06.2006 01:28:02 |
|
|
Macros for Excel 2000
I'm now using Excel 2000, but was using Excel 97. I had macros stored in the
Personal.xls and saved in the XLSTART folder. Where do I put this file for
Excel 2000 so I can still use these macro?
Thanks for any help...
|
7 |
10.06.2006 01:22:01 |
|
|
Excel landscape double sided, one side upside down - remedy?
Trying to print double sided sheets in excel - formatted in landscape. It
keeps printing the second side upside down. How do I remedy this please?...
|
2 |
10.06.2006 01:16:02 |
|
|
Import Data
In Excel, Data | Import External Data | Import Data.
Select Data Source. My Data Sources comes up. Press History, then select
the drive, and then the location. Works fine.
Most other programs remember the directory last opened, and opens to
this directory by default. How can I change the default behavior to open
to the last directory, rather than My Data Sources? How can I make Excel
...
|
1 |
09.06.2006 13:12:44 |
|
|
Excel Template Startup
I have an Excel template file that starups automatically when I start Excel.
I stored my template file in the Startup folder; path C:\Program
Files\Microsoft Office \Office11\xlStartup\MyTemplate.xlt.
I exit the program and startup Excel, it opens the template but with the
extension of xlt instead of xls. How do I get the template to open as an xls
file?
Thank you... Elaine...
|
1 |
09.06.2006 05:53:01 |
|
|
i have an xls file i cannot open in my computor.
I have a xls file i cannot open . i went to control panel and folder options
and i do not have an xls folder in there . what can i do now to open it?...
|
2 |
08.06.2006 22:11:27 |