Font usage legality
If I want to use a certain font on my business cards and
brochures, and my company logo, is that legal?
...Help: AutoFilter not 'hiding' data from other formulas
I'm using AutoFilter on a columns of personal data for which I've set
up other calculations (averages, percentiles, etc). I was hoping that
if I filtered, say, just for women, then the other calcualtions would
reflect only the women's data, but they still seem to reflect the whole
column of data, including data that's hidden by AutoFilter. Is there
any easy way to fix this? Thanks!
Do you mean that you have some SUM( ... ) formulae which do not change
to reflect only the displayed values? If so, you should change these to
SUBTOTAL(9, ... ).
Hope this helps.
C...Opening a new instance of Excel
I am using multiple monitors for work and it is great! Is
there a setting that I can use so that it opens each new
excel file in a new excel window so I can drag different
ones to each monitor? Is there a similar setting for Word?
I am using Excel 2002 and Word 2002.
Yes, you can check the Windows in Taskbar checkbox in
Tools; Options. This is on the View tab for both Word
>I am using multiple monitors for work and it is great!
>there a setting that I can use so that it opens each new
>excel file in a new excel ...how do I add times in Excel and result in hours & mins
I want to insert a time when I start work and a time when I take a break,
then a time when I leave work.
Following that I want to be able to add up the amount of hours that I have
This will enable me to plan my week ahead and ensure I only allocate a
specific amount of time to a project.
Microsoft MVP - Excel
"Rty Shaw" <Rty Shaw@discussions.microsoft.com> wrote in message
>I want to insert a time when I start work and...Illegal operation error while printing EXCEL or WORD Files
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...VBA from another app: Suppressing Excel confirmation dialog?
After creating/formatting several worksheets from MS Access, I'd like to delete
the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add.
I avoided using them because I'm not sure how/why they are created - i.e. maybe
some user's defaults would only create 1 empty sheet or none.
So, form MS Access's VBA I'd like to do:
On Error Resume Next
On Erro...Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...Emailing in excel 2003 02-26-10
If i type in the cell A34: neil.Holden@test.com and press a button is it
possible to email to the address of what ever is in A34 is?
The email body should say: this has been submitted for cell B34 and todays
Check out Ron De Bruins "Send-Mail" tips:
"Neil Holden" wrote:
> If i type in the cell A34: neil.Holden@test.com and press a button is it
> possible to email to the address of what ever is in A34 is?
> The email body should say: this has been submitted for cell B34 and...Formula help... #3
In column A there are cells with team names in them like the following:
I would like column B to list all the team names without the @ symbol and
column H to list all the teams with the @ symbol. For the example I would
like column B to have
(remove nothere from the email address if mailing direct)
"Jambruins" <Jambruins@discussions.microsoft.com> wrote in message
news:135965C4-7523-47AB-88DE-D0B12B652CD5@m...outlook 2007 runs slow
Outlook 2007 runs slow. Is there a way to speed it up.
Do you have the outlook performance update installed?
Are you using a Dell laptop?
Did you upgrade from an older version and are still using that profile?
http://www.slipstick.com/outlook/ol2007/slow.htm - install the update
listed at the end - also make sure all OS and Office updates available
through Microsoft update are installed. If it's still slow, try the various
solutions that apply to your situation.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Ta...Does anyone have a dashboard gauge (speedometer style) for Excel?
I am trying to create dashboard charts from Excel data and would love other
templates not available in Excel today - speedometer charts, multi-dimension
comparitive charts, charts that build information overlays.
I regularly create these in a manual way for executive and customer
summaries but would appreciate the ability to automatically generate these
types of charts allowing for real time viewing of "what if" scenarios.
Steve, there are tons of these things out there to review, few better than
Andy Pope has put together...Countif formula between numbers
I'm have a bad day and can't figure this simple question out. I want Excel to
count a column of numbers and show the the total cells with values between
100 and 125.
The formula I have thus far is '=countif(H5:H125,">=125<=100")
why is this not working???
This has been asked about a dozen times today. Homework assingment?
=sumproduct((rngA>100)*(rngA<200)). modify to suit
"dandigger" <email@example.com> wrote in message
news:1D44A5E6-ECAB-441D-B9D8-409D23D0369E@microsof...Exchange 2007 Evaluation version #2
Can I install it on 64 bit platform and run it as production?
On Fri, 23 Feb 2007 09:55:13 -0800, RG <RG@discussions.microsoft.com>
>Can I install it on 64 bit platform and run it as production?
There isn't an evaluation version as such.
You can install Exchange 2007 without a key for 120 days.
...Default font for PowerPoint slide
PowerPoint Office 2001, Mac OS 9.1
Is there a way to set a default font so that every time I choose a blank
presentation from the options shown in the "new slide" box that appears,
the default text font and its various attributes will be as I want them
-- say, Arial 24 pt.
Right now every time I open a new blank slide, the default text font is
Times 24 pt. How did it get to be that?
Thanks for your patience - you can see that I don't use PP very much.
I've also posted this to the microsoft.public.mac.office.powerpoint
-Barb, <www.jamlady.eboard.c...worksheet size in bytes
is there any algorythm/function to know the size of given excel
worksheet in byte?
Tamas Nagy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28000
View this thread: http://www.excelforum.com/showthread.php?threadid=475020
I think you'd have to save the worksheet in question as its own workbook.
While you could add up all the characters in all the cells that's only a
part of the picture given that many other things are part of the sheet,
I use Excel and Word 2003 using Windows NT. I've kept some files on a jump
drive so I can work on them at home. I attempted to work on a Word documents
which had an Excel worksheet inserted in it. I tried double clicking on the
worksheet to edit it and Word and Excel shut down. Now when I attempt to
open Excel at home it asks for my Office XP Professional installation cd. (I
have Office XP at home with Windows XP). I'm having a hard time locating my
original discs. Does anyone have any suggestions or experience anything like
...EXCEL TROUBLESHOOTING #2
I have an excel file (2000 format), that after I made a
number of changes is causing me problems when I re-open
the file. Windows task manager goes to 100% CPU
activity, and i cant do anything within the excel file.
However, if I set recalculation to manual before I open
the file, all seems fine.
Obvioulsy I have a problem. But how do i find that
Thanks in advance.
I have had some experience running large spreadsheets lately. Above a
certain size, the recalculation time seems to climb very fast. While Excel
is recalculating, you can't do anything anyway.
Best in my v...Excel Edit F2 button changed for Mac???
Switched to Microsofts version of Excel for Mac. Can anyone tell me
what keystroke allows me to edit a cell? Before I switched to a Mac
it was the F2 button. Please help. Thank you.
See the answers in the m.p.mac.office.excel newsgroup.
In article <firstname.lastname@example.org>,
> Switched to Microsofts version of Excel for Mac. Can anyone tell me
> what keystroke allows me to edit a cell? Before I switched to a Mac
> it was the F2 button. Please help. Thank you.
...allowing or disallowing changing the state of check box
what's the best moment to check if the user has right to change the state of
check box and then to allow it or cancel it. I've tried with "before update"
event procedure. It seems to work but after, when I press anything else on
the form event procedure is repeating?
The problem occurs (repeating) when Cancel = True was applied previosly.
> what's the best moment to check if the user has right to change the state of
> check box and then to allow it or cancel it. I'...Changing Posting Settings
I just wanted to double check that if I am currently Posting TO General
Ledger in the Purchasing Series, if I change that to Post THROUGH General
Ledger will this have any ill effects.
I would make sure everyone is off the system, however if there are batches
in the GL that were generated by the AP subledger is this ok and would it
then post through the general ledger for any new transactions posted once I
change this option?
You are fine. Manual post any GL batches. You can do this before or after you
change the option.
> I just wanted to double che...Excel Cells Contents to HTML Pages
I have an excel sheet which has two columns.
Column 1: PageName
Column 2: HTMLCode
PageName has information like: OurServices.htm which is the name of th
HTMLCode clumn has actual HTML Code like:
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html
charset=windows-1252"> ...In Excel program shows a broken line and don't know how to get ri.
I am trying to put in entries in Excel program and when I go to Print
Preview, it only shows part of the entries I put in. When I go to the last
entry that it shows in Print Preview, there is a broken line between it and
the next entry. I don't know what I did. I could use some help
You probably have multiple areas selected for your print area.
you can check this by <view><page break preview>
One possibility to correct this would be
<file><print area><clear print area>
or specifically select the area you want printed and
<file ><Print area>...Office 2007 Compatibility Pack 12-10-09
My new Windows 7 laptop came with a trial version of Office 2007 (Student),
which I uninstalled prior to first use. However, I have the PowerPoint
Viewer installed, which I use. Question: There's a huge 173 MB Office
Compatibility Pack in the Control Panel, Programs and Features, which can be
uninstalled. Can I uninstall this without any effect on the PowerPoint
Viewer or Microsoft Works (or Windows Live Mail) programs? Thanks.
Hi, Lone Star,
The compatibility pack is actually quite useful if you are running a
previous version of Office. Are you only using W...Excel to check for regular expression?
How do you use Regular expression in excel? For eg: Check a column of
data to see whether are all of them valid email addresses?
By valid, do you mean that the email is in proper syntax or that it is an
actual email address.
Text formulas can be used for proper syntax. Perhaps a Visual Basic
I doubt you can check that the email address actually exists, as many
companies and ISPs will simply disregard and drop mail to invalid email
addresses to eliminate spam
> How do you use Regular expression ...powerpoint texbox issue
Sorry for posting this twice but I could not find my previous post, but I
really need some help here.
We have a ppt 2007 problem. The problem is on our CEO's computer too!
We have ppt 2007 with all updates/service packs. The user will create a
textbox in powerpoint and starts typing, then saves the ppt file. When the
user goes back into the ptt file and clicks in the textbox and starts typing,
"randomly" the font will increase and the user has to set the font back.
Why Microsoft, why? This person uses powerpoint probably more than anyone
at our company, sin...