flag for follow up Help
Using Microsoft Outlook 2000 SP-3. My Flag for Follow Up
quit working, in my in box, but I can flag in other
folders. Anyone else ever have this problem? Please advise.
...New Outlook user needing help
After trying to sync my mobile phone & Pocket PC with Outlook 2000 on my
computer the '+' prefix (i.e. + 44 1234 567890) which I have for all my
do not show up in Outlook contacts. Even when I enter the '+' manually at
the beginning of the number when I press save it disappears.
What is most annoying of all is when I sync my phone with outlook again it
even replaces all the numbers in my phone without the '+'.
Can someone shed some light as to what settings I need to go into to resolve
this problem...Many thanks
...Need offset function help, I think
I have 10 products rows with a cost in column BW of rows 21 thru 30,
i.e., cells BW21 down to BW30.
Those 10 products have the # of units sold each month, for 22 months,
shown in rows 41 thru 50, in columns E thru Z, so column E is month
#1 ... col Z is month #22. The total range is cells E40 thru Z40.
There is a cost factor vector that has six factors in row 70, cells
G70 thru L70. These are to be used =91for all time periods=92 and for all
Any time there is a sale of a product in a certain month, I want to
enter six months of cost associated with producing the item...Why won't ADDRESS work nested inside SUMIF?
If I do this:
If I do:
I get an error. However if I do:
I get the answer I want. However, I'd prefer to not have a helper cell.
Some lateral thoughts, with emphasis on resolving the core issues you raised
in your other, earlier thread
Let's say you have col data in groups of 3 cols, with headers in row2 (eg:
Period1, Period2, etc), where each header is placed only in the l...How zoom/increase font size of Office 2004 "Help" text?
Font sizes can be set for Word, Excel and Entourage. You also can zoom in
to enlarge the View of text in Office 2004 components� documents.
How does one do this with the small-font text in Help?
On 9/14/04 1:36 AM, in article
BD6BFBA9.49F3firstname.lastname@example.org, "Norman R. Nager, Ph.D."
> Font sizes can be set for Word, Excel and Entourage. You also can zoom in
> to enlarge the View of text in Office 2004 components� documents.
> How does one do this with the small-font text in Help...Please Help #2
I am trying to share out a users calander to a group of managers. When I
to properties on the calander it adds them ok. When I go to add them in
properties under the users mailbox in Outlook 2002 on Windows NT it gives
the message "The modified permission could not be saved. The client
operation failed." I have read article 323611 on a workaround, but this
not work. We are using Exchange 2000, and I know when I started my
predisesor was backing up the M drive on the Exchange server, so when I
at the security settings on the users box on the M drive it...Help with Excel Workbook
I am updating a workbook and very behind. It's a construction workbook, so
there many separate categories that have to total costs
For example, electric, plumbing, misc....etc...and then theres a totals
page. What is the easiest way to input info? Can I input all info on one
Not sure if this has anything to do with Outlook. You might have better luck
posting in an Excel newsgroup.
"Nina" <Nina@discussions.microsoft.com> wrote in message
>I am updating a workbook and very behind. It's a...Please help w/formula
I want to create a formula for an employee schedule to compute the totals hrs
scheduled, multiply total hrs scheduled by rate of pay to get a gross rate of
pay. I can only get it to add up to 24 hrs then it starts over at 1.
Example I am using:
Where A2 is start, A3 is finished, B2 is rate of pay
Format cell to currency or accounting.
*Remember to click "yes" if this post helped you!*
> I want to create a formula for an employee schedule to co...New to excel Help
I am new to this forum and not good with excel.
this is a brief explaination of what i need to do to kick things off.
hop somebosy can help
have a calculation for temperature that i have 25 deg figures for.
need to be able to create a excel calculation for any given value (i
deg). I have a table of values run from a line of best fit basis.
so far my equation is eg
F1=D1/ratio in table pre determinded by the temp in E1
Can anybody help
sway's Profile: http...Frank Kabel...need your help
I've got MSQuery setup to retrieve data from an external database. I have a macro that automatically refreshes the data when the file is open. It's very cool because I've got it setup to prompt for the parameters (e.g., beginning date, ending date)
I'd like to complete the automation of this spreadsheet by telling Excel to refresh all the pivot tables in this workbook, AFTER the data is DONE being downloaded.
first: you may use a different header for this kind of
postings: Just stae your problem and don't address a
question directly to one of the regulars....Please help! MS Exchange Server is sending personal info!
I have all my personal banking, credit card numbers, passwords,
drivers license #, ect, on in my contacts. And some sensitive info in
notes. My company just changed to an inhouse server and is using ms
exchange and it copied my contacts folder to the server, which can
certainly be viewed by anybody in the office. And I run the risk of
all this going everywhere. I went on the internet site and deleted
everything I could, but now I can never go into outlook while being
connected to the internet. Please help! What is the best solution?
Mark your contact properties in the permissi...pivot table help #2
I am extremely new to pivot tables and trying to just get ave, max, and
min of a couple of columns ... I keep getting #DIV/0! errors and don't
know what the problem is. any ideas anyone???
evg1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35043
View this thread: http://www.excelforum.com/showthread.php?threadid=547887
Do you have errors in any of those fields in the raw data?
Do you have any numbers in the field that you're averaging?
> I am ...network key pw help
I have forgotten my network key pw for my wireless router
my lap top has the pw saved so i can get onwith that pc but i need the pw so
i connect with another lap to is there any way to retrive this pw??? I am
useing the window connection for connection
Mike <Mike@discussions.microsoft.com> wrote:
>I have forgotten my network key pw for my wireless router
>my lap top has the pw saved so i can get onwith that pc but i need the pw so
>i connect with another lap to is there any way to retrive this pw??? I am
>useing the window connection for connection
We carry circa 25 products.
Each product needs to be processed in 2-3 stages. circa 20 minutes/
Raw materials come in several times a month. However for some products
the raw materials are readily available while for others 1-2 months
Each product is packaged differently.
Each consignment consists of a product mix. (between 1 and 25) There
are circa 5 large customers (2000 products/month) , 5 medium ones (200/
month) and 10 small ones (20/month). (but none of these
order every single month). At the moment most customers need to wait
circa 2 months but the planning must be...What is wrong with this IF statement? need help.
This statement works fine but I want the cell to say 0" if the cell H6 has a
zero in it. As the stetments stands right now it displayes 6" in the cell if
H6 is 0. How can I make that happen?
Pleas...help me please
I have a nice problem for you - so please help me!
I have a property sheet with three pages in it. I make a pointer to the doc
class. I receive a value from the doc class. When I�'m going to use that
value - the value has changed, so I receive an exception. How can I get the
right value from the doc class? Is a doc class' value a word or a dword?
The doc class reference is a pointer. It is not a word, and it is not a dword, it is an
address. This means it could be 64 bits on a 64-bit machine. Never assume that a pointer
is 32 bits. The pointer to a CDocume...Loven test for there help
...Trying to understand rules, please help
I have an Exchange 2003 and I needed to create aliases that would
forward to several external email address (like email@example.com
forwarding to firstname.lastname@example.org).
What I did was to create a user named email@example.com,
assigned all the aliases to it (jdoe, janedoe, somebody and help) and
create rules that will redirect based on "Sent to" to the external
addresses. For better understanding of my problem I post two examples
Apply this rule after the message arrives
sent to firstname.lastname@example.org
redirect to email@example.com
and delete it
and stop processing more rules
A...Need some help from you smart people...
I have a spreadsheet that has multiple columns (13) that are variou
milestones. These columns contain dates that range over a period o
time given in day, month and year (11/18/2003). My question is, how ca
I filter, sort, etc...by a given date range i.e. for a 3 month period?
I hope that this is clear enough to get some feedback.
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
If I understand your intent, you need to use Data > Filter >AutoFilter....Help! Need to add/delete email users
We are a nonprofit in a sticky situation - our old
consultants are terrible and we are replacing them next
week, but in the meantime I have a new assistant starting
on Monday and need to get rid of the old assistant's
email/login and set her up. I am the most skilled at
computers in our office unfortunately, and am in the
network room (luckily it is logged on) but have no idea
where to find a place to change it or how to change it. I
am guessing its not too difficult if I'm pointed in the
right direction. We can't have the original consultants
come in to do this so any...Can not receive Email.. Need Help
Earlier this morning, my exchange server 2007 (hosted on SBS 2008) just
stopped receiving external e-mail. We can send interoffice e-mails and we can
send out e-mails to other locations fine, but we are unable to receive any
e-mail. All internet connections are normal as well, and the port 25 is open
on the firewall.
The error from when we try to send an e-mail to the server is this:
“This is an automatically generated Delivery Status Notification. Delivery
to the following recipients failed.”
Earlier today I installed the anti-spam update from MS “Microsoft excha...Help please? #3
sorry thanks its working! :
H4Fi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1625
View this thread: http://www.excelforum.com/showthread.php?threadid=27657
...Self joining table and grouping help
Could some help me with the SQL without using PARTITION and RANKING functions?
Or would that be asking too much?
pk_id, parent_id, trx_date, amt
1, 0, 3/7/2008, 2500
3, 0, 5/2/2008, 5000
48, 0, 12/4/2009, 2000
109, 0, 12/9/2009, 5000
101, 48, 12/6/2009, 2000
118, 48, 12/13/2009, 4000
145, 48, 12/13/2009, 2000
229, 48, 12/20/2009, 2000
313, 48, 12/27/2009, 2000
397, 48, 1/3/2010, 2000
482, 48, 1/10/2010, 48400
122, 109, 12/13/2009, 1365
149, 109, 12/13/2009, 5000
233, 109, 12/20/2009, 5000
317, 109, 12/27/2009, 5000
401, 109...Excel 2003, Auto Filter Help!
I have a 21,000 row XML file that I pull into Excel every morning:
Data / Import Data / Select Data Source / OK ...and all is well
....until I updated to a new PC and had to reload Excel. Now I get
autofilters at the top of each column, and it won't load all the data.
I know I can go in AFTER I load and uncheck Data / filter / autofilter
and it will remove the filter queues on the top row, but I DON'T know
how to set up an option where it will not format with auto filters
from the get-go. ...so I can load this data completely.
What am I missing here?! Thanks!
- Hu -
...Getting Creative With Notes
While I realise that this is totally unsupported I was wondering if
anyone had ever tried the following:
I have added an iFrame to a Service Activity to which I am assigning
the URL during the form's load event. If the SA has a Case (incident)
specified in the "Regarding" field I use the GUID of this case to
build up a URL that references that Case's Notes for example:
This works in so much that you can now see any Notes that have been
created on th...