Excel 2000 sorting doesn't remember sort columns
I have an excel 2000 file that has several different worksheets. A few
I need to sort occasionally. One of them has no problem, I can just go
to data->sort and it remembers what I sorted by last time. A couple of
others I have to re-choose the columns each time; it doesn't even
remember whether the worksheet had a header row. Anyone know a fix for
Can you assign a name to the range on each sheet that you want to sort?
For example, if your headers are A1:H1 and data is A2:H1001, select the
range A1:H1001 and assign it the name Sort_Range. If you have not done th...explorer crashing when I change to thumbnail
Every time I change one particular folder to thumnail view on my ahrd drive,
explorer crashes and I get an error. I have screenshots if that will help
anyone. This all started after I did a Windows update and I'm a little tired
of having to go onto another computer in the network to view files. I'm
afraid to move anythign because I dont' want this to happen elsewhere. Please
Ur spiel chukkers broke two
thumbnail problems wrote:
> Every time I change one particular folder to thumnail view on my ahrd
> explorer crashes and I ge...Excel file name
Recently, Excel started saving my spreadsheets with the name I give the
file followed by the .xls extension. Now, when I use the file name in
the header or footer it appears on my printed report as "ABC Report.xls"
rather than just "ABC Report". I don't want the .xls to appear, and
can't figure out how to get rid of it. What happened and how do I
change it back? I am using Excel 2002.
Thanks for your help on this small, but very annoying problem.
You probably changed an option in Windows Explorer. I'd leave it at the
new setting (it's safer to see th...Exporting EXCEL data in text (cvs) format
Is there no way to export EXCEL data to a text format e.g. cvs :
You can import from this format, why no export? Any work around?
I'm the first person in the universe who wants an importable text version of
his EXCEL data?
Woops! I didn't see the other options in the save as pulldown list. Sorry!
"Simon Wigzell" <firstname.lastname@example.org> wrote in message
> Is there no way to export EXCEL da...::: How to change formulas so I can copy them ? :::
I made formulas that are working good. But I can not copy them easily.
Can anyone help me ?
My problem is detailed into the following Excel file http://cjoint.com/?hpv1YggtI1
Thanks for your support.
Try these formulas:
C7: =HLOOKUP("ACTION TIME",DataBase!$C$6:$EA$11,6,FALSE)
D7: =HLOOKUP("ACTION TIME",DataBase!$C$6:$EA$11,5,FALSE)
E7: =HLOOKUP("ACTION TIME",DataBase!$C$6:$EA$11,3,FALSE)
The dollar signs ($) "Lock" that part of the reference so it won't change
when copied and pasted to another location.
Another alternative woul...Changing Values by Grouping and Dragging
Using OL 2003
Is there any way to change the subject line of a bunch of tasks or
appointments at the same time?
I used to be able to do this by grouping the items by subject and then
dragging the highlited items to a different group but it won't work now with
Same thing for changing the Contacts associated with a Task or Appointment.
...Change chart type in single data series, Excel 2007
I can't get it to change the chart type on a single data series in the new
Excel 2007. The "change chart type" is grayed out. Thank you,
What kind of chart is it? If it's a 3D chart, you can't change only one
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"momof3" <email@example.com> wrote in message
>I can't get it to change the chart type on a single data series ...OL 2002 SP3: Documentation bug about client-only rules
There is incomplete information under the "My rule name contains Client
Only" section of "Troubleshooting Outlook Rules" page (located at
It fails to mention that adding a rule to look for specific words in
recipient's address also will also cause the rule to become client only.
...Solver Add-In for Excel
Where can I download the Solver Add-In?
"cram" <firstname.lastname@example.org> wrote in message
> Where can I download the Solver Add-In?
With Excel 2003 it's on the cd: Tools - Add-Ins then select the Solver
you can't download it. It should be on your installation CDs
> Where can I download the Solver Add-In?
With all versions of Excel it is on the CD. You can purchase an
enhanced version at
J...Changing from HQ to Single Store
I had two stores, one of which I have closed down. I was using HQ. All
of my customers were set up as global customers. I have customers that
purchased on credit and made payments in both locations. Now I want to
eliminate HQ all together and just make my company a single store
environment. I want to eliminate the HQ computer and second store
computer. When I shut off the HQ computer, I can't check customer
balances and make payments to customer accounts properly, and I can't
send out statements. How can I go from an HQ to a single store
environment and preserve all of the acco...My Word Document is formated wrong on a PC
Operating System: Mac OS X 10.6 (Snow Leopard)
I went for a job interview the other day and when I looked at the Resume they had printed out the formatting was off. The spacing between the sentences were ok but the type that should of been on the second was half way down the second page. I took my original PC word doc. and opened it up and the Mac and it's the same way only it backwards most the type that should of been on the second page most of it was on the first page. I even made the PC word doc a .rtf file but it's still wrong and I can't se...Excel 2007
I cannot find the option to fill my charts with patterns (lines, dots,
crosshairs, etc.) in MS 2007. Help, please.
Excel 2007 is a Windows version � you've posted to the group for Excel on
the Mac. However, when you select a chart in 2007 there is a special set of
contextual tabs that appear towards the right end of the Ribbon. Explore
them as well as right-clicking chart components & selecting Format
[Whatever] from the shortcut menu. But if you're looking for the same
mundane bitmap Patterns provided in previous versions you won't find them.
They may ...Locked out of Exchange Administrator/directory for site, changed system account
I administer a single Exch 5.5 organization with two
sites, one server per site. In Exchange Administrator,
while connected to one of the servers, I must have
inadvertantly removed a permission from the one-and-only
system account configured for each site.
Now when I start Exch Administrator in my default site I
get the following error:
A connection could not be made to the Microsoft Exchange
Server computer 'name'
You do not have the permissions required to complete the
Microsoft Exchange Directory
ID no: DS_E_INSUFFICIENT_ACCESS_RIGHTS
I can connect ...Excel protecting formatting
How can I prevent cell formats from being removed or
being overwritten when data is cut or pasted from another
I do not wish to rely on users having to use the "Paste
Maybe you could just intercept the change. This worked in light testing.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myFormulas As Variant
On Error GoTo errHandler:
myFormulas = Target.Formula
.EnableEvents = False
Target.Formula = myFormulas
Microsoft REALLY needs to support Excel drop down boxes for the pocket PC.
Inputting is cumbersome with the Pocket PC and if there ever was an
application that where drop downs would be useful it's on pocket excel. I
realize some functionality must be sacrificed .... but not drop downs!
How about a patch to upgrade?
as this is a peer-to-peer newsgroup you may try emailing MS directly:
"brian" <email@example.com> schrieb im Newsbeitrag
news:4C8E8833-6EC6-45CC-82FC-6830F2B25FCF@microsoft....Need a formula for Excel 2000..
Greetings & bless your little cottons for existing. I've never don
anything more than autosum before and now my workplace has gifted m
with a spreadsheet project that looks monumental to me. Can anyone tel
If, in Sheet 1, the cell range C2-C41 contains "Cohen" anywhere AND th
cell range R2-R41 contains "allowed" anywhere, I need to have th
number of times that these two conditions are satisfied displayed a
that number of times, in Sheet 2 at cell B2.
So far I have =(IF((C2:C41="Cohen")*(R2:R41="Allowed"),)
I can't find the command...WXP registry to prevent changing of OL2003 tracking options?
For those stand alone computers (i.e. won't/can't logon to AD), I would like
to enforce outlook2003 email tracking.
After I enforced the settings in outlook2003, users can
accidentally/purposely revert the settings so that I can't track the email
If there is any Winxp registry settings which can prevent users to change
that email tracking settings?
Not that I am aware of - however, whatever you do, they can undo. I
personally hate tracking - many people use it to just check on you so that
they can call you. I never return read-receipts t...Why does the layout on a page keep changing?
I am having the weirdest difficulty with Publisher 2007. I use Publisher to
create a multi-page bulletin. I had one template I was using for a 12 page
bulletin. I used that for about a year. Then I changed to a new template
that was 8 pages with a different font. The problem I am having is that when
I open one of the old bulletins now (and have done so on multiple PCs) the
formatting is all messed up. Text boxes that were full of text are now
showing as blank, and the spacing is all messed up.
Why would Publisher do this?
...Using excel if function on a pricing spreadsheet
I am trying to simplify a pricing spreadsheet that I use at work. I a
using the following criteria; the $ value of a product, the descriptio
of a product that I have on a cost page. What I want to do is when
type in the description of product X in a specific cell, I want the
value of that product returned to another specific cell.
Example: Lexan14SS (in a cell); 1.75 ($ value in another cell).
On a pricing spreadsheet I type in Lexan14SS and I want that specific
value returned to another cell. Of course though i will have mutipl
product descriptions and prices to go along with those produc...Convert text to number
Thanks a lot to everybody. Unfortunatelly I cannot attach .xls file
that I receive, because of excelforum's restrictions, it looks like
usual excel file. I will try to use the advice of Debra.
Irina's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=8685
View this thread: http://www.excelforum.com/showthread.php?threadid=263454
...Excel template similar to MS Money less investments?
Is there an Excel template or freeware that does the recording functions of
M/S Money but doesn't involve investments and live updating ? Basically I'm
looking for a check book program that makes some reports possible.
...cant open Excel 2000 workbook with macros in XP
I cant open any excel spreadsheats with macros that were made previously the come up saying this has a macro from 4 cant open in high security environmen
Can anyone help?????????????
Try changing the security settings on the xp excel.
"Murray Thompson" <firstname.lastname@example.org> wrote in message
> I cant open any excel spreadsheats with macros that were made previously
the come up saying this has a macro from 4 cant open in high security
> Can a...Importing into Outlook 2003 from Excel (ss created in Office 2000)
Am having difficulty Importing data into Outlook/ Contacts
2003 from an older spreadsheet created in Office 2000.
Everything in steps to import works except the actual
transfer of data: e.g., the first field in the Excel
spreadsheet ("City" field) imports correctly into Contacts
(without any of the other imported fields). Then blank
records are added for as many records there are in the
next field: "Company" name.
Have cleared all Flags during the Import/Export function
in Outlook and am totally stumped as to how to fix.
Thanks so much for the help.
...DOUBLE CLICKING EXCEL ICON
I have uninstalled and reinstalled Microsoft's Office Pro with Frontpage.
When I double click on an excel in a file without first opening the excel
program, excel opens but it cannot find the file that I double clicked. Can
anyone help me with this problem?
Sometimes one of these works:
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close Excel and
Windows Start Button|Run
Windows Start Button|Run
The /unregserver & /regserver stuff resets the windows registry to excel's
Wayne Ri...How do I plot a v-mask in excel?
Anyone know how to take a Cusum chart and plot a v-mask on it?
And for those not in the know, what is a v-mask?
Andy Pope, Microsoft MVP - Excel
"JerryA" <JerryA@discussions.microsoft.com> wrote in message
> Anyone know how to take a Cusum chart and plot a v-mask on it?
On Fri, 11 Jul 2008, in microsoft.public.excel.charting,
Andy Pope <email@example.com> said:
>And for those not in the know, what is a v-mask?
I googled, thinking "cusum" might...