Change 2007 excel Autofilter back to 2003?
Does anyone know if there is a way to change excel's 2007 autofilter
functionality back to like excel 2003 autoflilter use to work? I need to
quickly bring up like values and compare other columns based upon the
filtered values and the extra clicking of the check boxes is driving me nuts!
If it helps any (and if you haven't thought about it yet), you can click the
"(Select All)" entry twice to remove your current selections.
Rick (MVP - Excel)
"jonnybrovo815" <email@example.com> wrote in message
news:36837406-1...How i change headers in different sections Microsoft Publisher 20.
I am trying to make a school newspaper using the Microsoft Publisher 2007.
Anad i heed to have different headers in different sections, i cannot do
that. The newspaper is going to be about 32 pages.
Are you using one of the templates? What template?
What happens when you try to change the headers?
Mary Sauer MSFT MVP
"Vasso" <Vasso@discussions.microsoft.com> wrote in message
>I am trying to make a school newspaper using the Mi...Changing Average Cost GP 9.0 Error
When we try to change the average cost information for an item per the
documentation, (tools >> utilities >> inventory >> change average cost), we
get this message. "Use the Inventory Adjust Costs window to change the cost
of one or more reciepts. The average cost of an item is recalculated when
teh changes are proceses"
We would like to change it without using the Inventory Adjust Costs window
because there are no recent purchases and receipts of the particular item in
Would anyone have any suggestions?
The average cost is the aver...Prevent change to refs in second worksheet when drag cells in firs
I have a complex calendar in Excel. Each week, admins Ctrl-drag cells among
different locations in the primary calendar worksheet. I have a second
worksheet that needs to list those cell values in a fixed configuration, e.g.
the value in Sheet1!A1 needs to always appear in the cell of Sheet2!G10.
Sheet2!G10 contains the formula: “Sheet1!$A$1”. If the user drags Sheet1!A1
to Sheet1!A3, the formula in Sheet2!G10 gets automatically updated to
“Sheet1!$A$3”. I have tried all combos of locking and protecting to prevent
this updating. Is there a way to do this?
Try referencing the other shee...How can I change default setting in Office start-up?
I need to change the default setting on my Word, Excel and PPT
programs (MS Office 2004) so when they open they aren't at, for
example, Word 11.3.0, rather at Word 11.2.3. I mac OSX, a G5.
When I do a control click on any of those programs, go to "get info"
and then choose the 11.2.3 that I want to open with, it does it no
problem. When I click "change all" it doesn't change the default --
the 11.3.0 is always the default despite that I'm trying to change
all. How do I fix this?
BTW this whole problem started when someone at the genius bar deleted
one of the...Change owner of a template in P12
is there any possibility to change the owner of a template?
Usually project owners can be changed in the Project Center of Project
Server 2007, but templates are not shown in the Center - or am I mistaken in
Background: A user created a template on the server and is thus the owner of
the template. But we would like to change this owner to be another user.
Thanks for your suggestions!
The template owner, which has no meaning in the grand scheme of things, is
always the person who saved the template to the server. If you want to
change the owner, then dele...Cant Change AutoCorrect List
I am using Office 2007 B2 TR, and I have found a problem with the
I removed some entries from the autocorrect list (the wingding smilies
specifically), but it doesn't actually remove them.
Every time I go back and write a new email, they are back. I have tried
through the message options, through the general outlook options, and
through the autocorrect smart-tag options. No matter how I try to get rid of
those autocorrect entries, they keep coming back.
Is there some magical way to get rid of them, or is this just a bug in the
Thanks in advance,
- Art...Microsoft Office Icons Change...
Operating System: Mac OS X 10.5 (Leopard)
I changed the basic icons that came with the office programs, but once I use one of the programs such as Word, the icon changes back to the default one. Even after I quit the program it stays as the default icon. Only when I manually change it does it use the new (better looking) icons I have, but only if I haven't used the program before.... Any ideas?
On 6/25/09 2:07 AM, in article firstname.lastname@example.orgR9absDaxw,
"email@example.com" <firstname.lastname@example.org> wrote:
> Version: 2...Counting Consecutive Years
I'm trying to count the maximum number of consecutive years that an
individual has made a gift to our institution. I have a range of 35 years to
consider and all my information resides in one table. It doesn't matter when
the last giving year was as long as s/he give 'x' number of consecutive years
before that (with 'x' being a user-defined parameter). I will also want to
know the minimum and maximum values for that range. I'm using Access 2003 and
know very little Visual Basic. Any help would be appreciated.
If the fields are like:
Name YearContribution ...How do I create a Cost Volume Profit Graph in Excel?
I was wondering if I could get some help on how to create a CVP graph in
A cost volume profit shows how costs, revenues, and profits vary with volume
(sales). You can either plot total cost, or fixed and variable costs, which
add up to total costs.
One way to show this is to make a break-even chart. Put unit sales (number
of items sold) in the first column, fixed costs in the second (which are a
constant), variable costs in the third column (these are typically a
straight line through zero), and in the fourth insert formulas that sum
fixed and variable costs to make total ...How do I change the default paper size (and units) in Publisher?
I've got the printer set to A4, but no matter how many times i change the
options in Publisher - everytime Publisher loads it resets to Letter/Inches.
> I've got the printer set to A4, but no matter how many
> times i change the options in Publisher - everytime
> Publisher loads it resets to Letter/Inches.
Go to Control Panel and carefully check the
Preferences and or Default settings for your
printer. There may be more than one place
to change paper size.
**MS Picture It! MVP**
*****Digital I...Changing Slide Advnacing timing
Thanks for your attention.
I have a PowerPoint presentation with more than 30 slides. Initially I set
the slide advancing to AUTOMATICALLY AFTER 00:05 secs for each slide. Rest of
the Slide Transition settings for each slide are different. Now I wish to
reduce the timing to 00:03 secs without changing other setting. (clicking
APPLY TO ALL SLIDES changes the Slide Transition settings in all slide to
identical as the one I am working on).
1. Is there a way to do this easily without having to go to each slide
2. If there is a way, can it be used to change ...Change default "SaveAs" to *.msg rather than *.html
Using Outlook 03, I regularly need to save emails and prefer to save as
*.msg so the attachments are contained within the one file.
How can you change the default SaveAs command to Save as Type in a *.msg
format (rather than *.html) so the type is already *.msg without having to
use the pull down?
Outlook provides no way to change that.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"TroyB" <email@example.com>...change column name from letters to numbers?
I'm importing a 3rd party CSV file into Excel and then comparing some of
the contents to a printed spec. Each numbered field in the spec
corresponds to a column in the work sheet. I'd like to change the column
headers from letters to numbers. Is that possible?
Tools-->Options, General tab. Check the R1C1 Reference Style.
"Jerry" <firstname.lastname@example.org> wrote in message
> I'm importing a 3rd party CSV file into Excel and then comparing ...Can you change the way quick parts and/or auto text displays?
Is there a way to change the look of the drop down menu for quick parts and
auto text so it does not take up so much space? Something like it looked in
Assuming that you have discovered the building block organizer - see
Like 2003 it ain't!
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<&...How do you change the way email addresses are displayed? John Doe.
How do you change the way a recipent of an emails name is displayed in an
email? I want to only show "John Doe" and not "John Doe (Email):<John
Displayed where and in what version of Outlook?
"dmoors" <email@example.com> wrote in message
> How do you change the way a recipent of an emails name is displayed in an
> email? I want to only show "John Doe" and not "John Doe (Email):<John
> Doe@xxx.com>&q...Excel cut/Paste Problem: Year changes after data is copy and paste
I am using Excel 2003, and here is the problem. I have an Excel sheet that
contains financials. Different departments need different sections of the
data, so I copy and paste out only those sections they need and paste it into
a new Excel sheet. The colums are broken up into dates, and formated to show
date-year (Dec-05). For some reason, when I copy and paste sections, the date
will change, for example Dec-05 will change to Dec-01. I have to go thru and
manually correct all the dates. Can anyone tell me what is causing this?
.. maybe the cells in the New worksheet are preset to a c...Changing of range (Address) to (Cell)
I have encounter a problem with the use of range
From a recorded macro, it's listed this way
ActiveChart.SetSourceData Source:=Sheets("Trend").Range("A1:M2,A24:M28"), PlotBy:=xlRow
And I edit it to this way
ActiveChart.SetSourceData Source:=Sheets("Trend").Range("A1:M2," & Cells(StartX, StartY), Cells(LastX, LastY)), PlotBy:=xlRow
And obviously VBA compiler won't let me go this easily, it happen to give an "evil-comment" on my source range, May i know how can i solve this
Try this, assuming the...Net change and percentage of change
I have a list of parts that have had price increases. One column has the old
price the other has the new price. I need to show the difference, whether it
is positive or negative and the percentage of the increase or decrease. The
difference is not a problem. The problem lies in calculating the percentage.
I don't how to do that. Can someone tell me?
> I have a list of parts that have had price increases. One column has the old
> price the other has the new price. I need to show the difference, whethe...problem in changing the text of sentences before tables
I am developing a word automation application. In a method of mine, I change
the text of some sentences of an opened word file, but the problem is when I
change the text of a sentence which located before a table, it will be moved
to the first cell of the table. My code is as follow:
void myMethod( long startingSentenceNumber, const char *toBeSearched, const
char *replacement, bool replace )
Sentences sentencesList = m_document.GetSentences();
long sentencesCount = sentencesList.GetCount();
CString replacementCStr(...Don't change text to numbers
I want to replace the character "-" into "." in cells formatted as text
eg 0060-1003 must become 0060.1003
i already unchecked in error checking : numbers stored as text
if i do it manually it is ok but because i want to do it by replace
to . and then it becomes 601003
How can i prevent this
Message posted from http://www.ExcelForum.com
Use a temporary "helper-column (a new inserted column)" let's say Column B:
and in Cell B1 enter =SUBSTITUTE(A1,"-",".") where A1 has your
0060-1003. Copy B1 down, then Copy B:B to B:B & u...Fiscal Year Close
v7.5 Great Plains
There is a user that went ahead and posted a large number of transactions
(not posted to GL, but sitting in batches there - only posted in in POP/SOP
with a tie in to Inventory) that are dated _after_ the projected fiscal year
Are these recoverable? Or do they all have to be voided (with adjustments to
inventory) and re-entered from scratch?
I think your best bet is to delete the unposted batches in GL and enter
returns to negate the transactions in POP and SOP.
Charles Allen, MVP
> v7.5 Great Plains
> There is a us...remove white space without changing plot size
Now I know the white space can be removed by draging plot area but without
changing the size of plot I like to remove the white space. Is that
Not impossible, but it is hard to maintain the plot area size. You have
to first make the outer chart area rectangle as small as you need, then
make the plot area as large as you need. You'll probably have to cycle
through resizing of the two rectangles a few times.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> Now I know t...EXCEL Decimal changes during WORD Merge
Why does Excel change 16 cents into .1599999 in a merge process
Have not had this problem until we upgraded to 2003?????
I have tried different cell formats in Excel
Number - currency - accounting - custom - all with the 2 decimal places
text - but rather not lose numeric functions
(am re-entering figures by hand and using text format today to finish
merged letters - - ugghhh!)
I have had a similar problem in previous versions of Excel as well, not just
Office 2003. Is the data in Excel coming from an outside source like a non
Microsoft database query?
I run into this probl...Getting rid of the location of the messages change message?
I'm currently running Outlook XP and Exchange 5.5. I created mandatory user
profiles for the end users. Basically their desktop and all their settings
are replaced with a generic one every time they reboot. They click on an
outlook profile every time they log in from the mandatory users profile.
When they click on the outlook profile file (outlook.prf), they will get a
message every time saying "
The location messages are delivered to has changed for this user profile. To
complete this operation, you may need to copy the contents of the old
Outlook folders to the new Outlook folde...