Strange Excel Problem.....
We are facing one very strange excel problem in our organization.We have
purchased new IBM thinkcenter 851 desktops for our Managers.We have installed
Windows 2000 professional as operating system and Office 97 as office in that
pcs.Now we are facing one very strange problem....Normally when you click on
"New" shortcut( I mean right click anywhere and select "new" option),you will
find "Microsoft Excel Worksheet" as shortcut listed in that option and when
you select it new excel worksheet will be opened.But here,whenever i click on
"new"...Excel remembers! How?
I type in "FRENCH"(no quatos) in cell A1
The I type in ENGLISH in cell b1
When I get back to cell a2 and type in the letter F the etxt is completed
and it says FRENCH
How does this happen/what is it called/how do you turn it OFF
Thanks for the help
It is called "AutoCompletion". To turn it off, go to the Tools
menu, choose Options, then the Edit tab. There, uncheck the
"Enable AutoComplete for cell values" options.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"ian&qu...Global Footers in Excel
Does anyone know how to take an Excel workbook that has
multiple worksheets and create a footer (say one that
lists the page number, the tab name, and the file name),
and make that footer a "global footer" such that I don't
have to set the footer for some 10 to 20 worksheets when
they're practically identical?
Right-click on one worksheet tab and "select all sheets".
Set up your footer on the active sheet and these settings will be replicated
on all sheets.
DO NOT FORGET to right-click and "ungroup sheets" when done. What you ...Problem sending an Excel file as an attachment in Outlook Express
I can receive Excel files as Outlook Express Attachments but when I send one
it changes to an .dat file and can not be opened. I use MS Office 2000.
this is more a Outlook related question. So you may post this in the
"Olgolfer" <Olgolfer@discussions.microsoft.com> schrieb im Newsbeitrag
> I can receive Excel files as Outlook Express Attachments but when I
> it changes to an .dat file and can not be opened. I use MS Office
...Excel Jululian 04-28-10
can i create an index sheet for all my excels files (XLS)
yes george, if thats what you want to do.
"George A. Jululian" wrote:
> Good morning
> please help
> can i create an index sheet for all my excels files (XLS)
oh, go on then
two ways - build an excel macro what gets the information from windows so
can (kind of) keep itself up to date.
I am guessing you have no macro background so i offer the much cheaper way:-
got to Start, run type "cmd" wi...Cursor highlights the wrong rows in excel?
I find that I have to select 3 rows above the row I want to highlight in
excel. This carries forward when selecting multiple rows. My mouse is always
about 3 lines above the cells being acted upon.
...excel 2007 installation
I used to have Excel XP and I install Excel 2007.
Problem: I want to ger rid of the personalized features I have in XP and
install Excell 2077 with the default parameters as it come from the
Did you try just uninstalling the Excel XP version first?
If so, did that not help? I've not tried this so I'd like to know!
"Elitor" <Elitor@discussions.microsoft.com> wrote in message
> I used to have Excel XP and I install Excel 2007.
> Problem: I want to ...Excel Caused Error in VBE6.dll. Excel will Close
When trying to open Excel 2000 (Office Professional) / Windows ME the above
message appeared and Excel would not open.
Renaming the VBE6.DLL file and then repair and then reinstal Office did not
work as the original dated VBE6.DLL file reappeared
Has anyone had the sme problem? If so did you find a workable solution? ...
and what was it?
...How do I copy a chart made in Excel to Powerpoint?
I have created a number of charts in Excel that I need to export to
Powerpoint for a presentation. I also want to turn each graph into a jpeg or
pdf file for publication. How do I do this?
For sharing charts in Office 2003 or earlier:
Using Excel with Other Office Applications
Office 2007 throws some wrenches into the gears.
To export charts as image files:
Enhanced Export Chart
Use PDF or GIF, which are optimized for line art, not JPG, which is
optimized fo...Excel 2007 Chart SeriesCollection(1).Interior.ColorIndex
I thought I had posted this already, but can't find it. Sorry if it's a
duplicate. I have the following code that was written in Excel 2003. Every
time I run it in Excel 2007 it crashes. I can't find anything about changing
the colors of a series in an Excel 2007 chart. Also, when I try to record a
macro to change the chart colors to gain insight, nothing gets written to the
macro regarding the color change. Help!
Sheets("Chart1").SeriesCollection(1).Interior.ColorIndex = 5
...excel spreadsheet 2003 wont show content when moved to another par
i have backed all documents which included excel spreadsheets from c drive to
d drive (ANOTHER PARTITION). Now i cannot see the content of the spreadsheet
when i access it from the D drive or C drive.
what have i done to it?
It also wont open when itry to access it from backed up USB stick.
I had a similar issue with some files. What happened was that somehow the
windows for the files got minimized or dragged out of view somehow (not sure
how this happened).
Users would open a file and see nothing.
This fixed it for me.
Goto the Window item on toolbar, S...How can I draw a Parabola in Excel? like y = x^2 + 3
In a1:a10 enter numbers such as 1,2,3....
In b1 type =a1^2+3
copy this down to B10
select a1:b10; click chart wizard; select XY chart
now play with values in A to get what you need
Bernard V Liengme
remove caps from email
"Max" <Max@discussions.microsoft.com> wrote in message
...E-mail stuck in Inbox, file in use, backup fails
I have a reoccuring problem that is driving me nuts. I have Small Business
Server 2003 with Exchange set up. A user keeps getting a specific e-mail in
her inbox in the mail store that kills the Veritas backup.
The e-mail never makes it to the Outlook 2003 client. If you use OWA, the
e-mail shows up there but it will not open. The page not found error is
HTTP 500 server error.
If you look at the log in Veritas, it says 'file in use' and 'access
denied'. On the weekend I rebooted the server remotely and then permanently
deleted the e-mail. The backup completed succes...saving excel file with it's add in
I have an Excel file that uses a formula from an add in installed in m
How can I save the project including the add in in order to use it i
another computer that doesn't have the add in.
Message posted from http://www.ExcelForum.com
Do you really mean that your workbook uses a function that's in the addin?
If yes, I think you have two choices.
#1. Take the addin with you (and install it on the other pc).
#2. Extract the code/procedure for that function from the addin and put it in
your workbook. (If the addin's project is protected, then thi...Pie Chart (excel 2003)
How do I hide the 0% of the pie chart so that they only show the relevant %?
If you mean on the pie then double click the data labels and choose the
Number tab, choose Custom and enter the following code on the Type line on
> How do I hide the 0% of the pie chart so that they only show the relevant %?
Thanks! It does look better.
But is there a way to not show the data lable of those 0% as well?
> If you mean on the pie then double click the data labels ...How can a set an alarm in Excel?
I don't know if this is possible, but I figured I would ask:
I have a spreadsheet that I work with that shows the schedules of my
students; each different place my student goes has its own row, so a student
may have many rows if they have many activities. currently, i auto filter the
day column to the current day so i can see what students have activities on
that day, and when/where they are. i was wondering if i could set an alarm on
the column labeled 'start time' that would pop a window up when any value in
that cell matched the system time... is this possible?? thanks,
-...Outlook 2000 #200
When I click on new message nothing happen but the hour
glass spins. When I click on a message in my in box the
hour glass also just spins. Any suggestions or help with
this problem is greatly appreciated.
...Access 2000 to Access97
I am trying to convert a Access 2000 database into
Access97. When I try this I receive a message saying 'The
size of a field is too long'.
Does anyone know how this database can be converted
...Mail icon on taskbar in Outlook 2000
A user right clicked on the mail icon on the taskbar and disabled it and
wants it back. In Outlook 2003 there is an option to add it back, I didn't
see anything in Outlook 2000. Does anyone know how I would do this? I am
thinking a reinstall/repair might do the trick but I was thinking there
might be something else.
...Upgrade from Windows 2000 to Windows 2003 Killed OWA
I upgraded a Windows 2000 Server machine running Exchange 2003, to Windows
Server 2003. Now after authenticating to OWA, "HTTP/1.0 503 Service
Unavailable" is displayed in the browser.
I seen this (http://support.microsoft.com/?kbid=305030 ) from another post,
but have not tried the items at the bottom yet.
In IIS, the VDirs, Exchweb, Exchange, EXadmin, were not using the
ExchangeApplicationPool, they were using the default. Plus I had to click
the create button next to application on all three. I tried and iisreset
after that, but it did not help. I also made sure the se...Opening .pub in earlier version (2002 in 2000) is it possible?
Jave file created in Publisher 2002. Can it be opened in
Publisher 2000. is there any download to facilitate this.
Ask the orginator to do a Save As to a Pub 2000 file. Warning: It may lose
something in the translation.
"P. S." <firstname.lastname@example.org> wrote in message
> Jave file created in Publisher 2002. Can it be opened in
> Publisher 2000. is there any download to facilitate this.
...Re: Excel Problem
This is a multi-part message in MIME format.
I have some sheets 1;2;3;4; ETC.................
I would like the new page list release with one botton:
A1-Nome de sheet(1;2;3;4; ETC)
"Bob Phillips" <email@example.com> ha scritto nel =
> I am not absolutely clear as to what you...Graphic features of EXCEL..........
I want to display the table data on Pivot GRAPH from two different sheets.
How should we do that?
Any advice will be great.
...Excel 2007 sorting problem
In Excel 2007, every time I change ranges, and even sometimes when I move
away from a range and then come back to an old range, I have to re-enter the
sort parameters every time.
In Excel 2003, and for some versions before, if I sorted a selected range
(say A4:Q54) by Col A Asc, Col G Asc, and Col C Desc then Excel would remember
the sort parameters so that if I changed ranges to say A60:Q100 it would
keep those same parameters loaded and I could just simply sort my data
without having to re-enter the sort parameters all over again.
Please direct me to where I can get some help on this issue...Excel text to Word text
How can I copy Excel text, then paste it into MS Word without carrying
over the grid lines? Any help would be appreciated. Thanks
I don't believe you can copy and paste without the gridlines. However, in
Word, select the data and Table>Convert>Table to Text.
Greeting from the Gulf Coast!
"Ed" <firstname.lastname@example.org> wrote in message
> How can I copy Excel text, then paste it into MS Word without carrying
> over the grid lines? Any help would be appreciated. Thanks