Help! I have some data that I am importing into Excel. I have a range
of cells that is 11 rows x 2 columns. What I need to do is simple. I
need to multiply each cell in this range by 60 without going in to each
one and typing =PRODUCT(60*........). Anybody got any suggestions?
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Put 60 in an empty cell, copy it, select the 11 x 2 range and
do edit>paste special and select multiply
&quo...Windows Live Calendar
Please add a way to associate an ICS file with the calendar
accessible from the Windows Live Mail menu!
It makes no sense to have to go to the Live Calendar online,
share calendar, import ICS file, turn off sharing and then
go back to the WLM calendar!
Right pew, wrong church! You'll find support for Windows Live Mail (WLMail)
in this public newsgroup: microsoft.public.windows.live.mail.desktop
Via the web-interface:
Via your newsreader:
news://msn...Calendar Meeting / appointment not updating
Apologies if this is duplicated, I tried posting a new question and it
crashed on submission so not sure if it will appear twice or not...apologies
if it does.
I have a strange problem with the Outlook calendar that I am hoping that
someone can give me some help with.
I have several users that are assistants to departmental heads, if they
edit/delete meetings/appointments from their bosses calendar then the changes
are not reflected when their boss looks at their calendar within Outlook. I
havent checked as of the time of posting this message whether its the same
vi...Strange problem with dragging mails to the calendar.
i use outlook 2000 SR 1 here. When we drag a mail to our calendar the mail
is added to the calendar. But we have a strange problem. The body of the
mail is not shown when the mail has been dropped in the calendar. When we go
out of the calendar and into the calendar again and open the appointment
then the body is shown.
but this is not easy to work with. because when you drop the mail in the
calendar you are not able to adjust the body because it is not show. is
their anyone who knows what may cause this problem and how to solve it
Have you tried right clicking and dr...Office calendars
Can conflicting appointments in Microsoft Office Calendars be prohibited?
...Permissions for Calendar/Inbox, etc
As the Exchange admin, can I set Calendar Permissions for another person's
calendar or do they have to do it themselves? If so, how do I do this? A
secretary needs to make entries into her boss's calendar, and he's out of
town, and never gave her the permissions to do it.
There is no interface in Exchange for allowing the administrator to set
individual permissions on a mailbox's folders. A quick-n-dirty (and lazy)
solution would be to give secretary "Full Mailbox Access" to the bosses
mailbox (using Exchange System Manager). However, this...Calendar 2008 version
I am having real problems with my Entourage calendar, all new meetings I
enter seem to disappear? I upgraded from 2004 - 2008 around 2 months ago and
although there were a few glitches importing data at first, I had no problems
entering diary appointments. All the dates I imported are still present, it
is just the new ones I enter??
I have been using Entourage for years and never had this problem before.....
> I am having real problems with my Entourage calendar, all new meetings I
> enter seem to disappear? I upgraded from 2004 - 2008 around 2 month...Share Calendar
Is there a way I can grant family members access to my WLM Calendar? Can I
post it online somewhere and they can go in and look at it? If you are aware
of a way to do this, can you please offer small, simple bits of info so I can
actually do it. I am not all that tech smart. Thank you.
"Maegan" <Maegan@discussions.microsoft.com> wrote in message
> Is there a way I can grant family members access to my WLM Calendar? Can I
> post it online somewher...Spacing Problems with Messages and Calendar Entries
Hello all, I hope my note finds you doing well. My problem is with paragraphs
and spacing when I send Outlook email or calendar events with information in
the Notes section. I send a message with single spacing, but when it arrives
to the recipient it has double spaces in between. For example, I may send an
email or calendar event with a note that looks like this:
Dr. Mary Jane
Department of Nursing
City, State 11111
But when it is received it by the recipient or my manger's calendar (in the
Notes section), it looks like this:
Conta...Multiplying two columns
How do I multiply column A (length) by column B (width)? All I want is a new column C (area) where the cells correspond to what I just multiplied if one were to look from left to right. A x B = C. I can do it for two numbers but not whole columns....
In (eg) C1
Point to bottom right corner until you see the plus
To get the sum of all A*B you can use:
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
...Link a Sharepoint Calendar to another SharePoint calendars?
Is there a way to create a SharePoint calendar that links and brings in the
information from other SharePoint calendars?
Have a look at
- you can play with SPD and marged data sources or play with different
content types within a single calendar. None of the approaches is perfect
however - you'd be better off using a commercial roll-up webpart or use
Sharepoint 2010 Calendar Overlay feature.
....your gateway to ...Multiple emails being received: Calendar
The system has sent me 12 acceptance mails for the same meeting.
Now I have cancelled a meeting and the system is generating multiple cancellation acceptances for this meeting.
Submitted using http://www.outlookforums.com
Are you or any of the attendees using an iphone?
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
I have a form with a auto assign number for the ID field. My question is
that if there is a way to attach the Julian date to the assigned ID?
Thanks for your assistance in advance,
I'm assuming that by Julian Date you mean something like 07320 for today,
November 16, 2007, the 320th day of the year. (That's not actually the
Julian Date, but it's a common misuse of the term).
You cannot change the value assigned to an AutoNumber field, but you could
add a second field to the table, with its default as Date, so that it'll
have today's date in it.
Once you'...How to multiply time?
I'm trying to do a quick and dirty time sheet where all I enter is hours
worked and hourly rate.
If the hours were whole numbers this would be simple but if someone works 40
hours 28 minutes
That would be 40.4666666...
I guess one way would be to have the whole numbers in one column and the
partials in another and then add them both once I convert the partials from
60th's to 100ths
A1 = total time in [h]:mm format as a true Excel time value
B1 = hourly rate
You will probably want to round the result to 2 decimal places:
=ROUND(A...Calendar Access via OWA
I have been assigned delegate permissions to a users calendar and I can
connect to her calendar from my Outlook. I want to connect to her calendar
via the OWA and I type this in the URL but no luck ..
Advsie please, Thank you.
"WILDPACKET" <WILDPACKET@discussions.microsoft.com> wrote in message
> I have been assigned delegate permissions to a users calendar and I
> connect to her calendar from my Outlook. I want to connect to her
>...Calendars for Publisher 2003
Here it is September 2006 and NO 2006 calendars for Publisher. When is
someone going to get up to speed and get templates for 2006 and 2007?
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=45906e5a-1759-...accept/decline not updating Exchange calendar
I use Outlook 2003 with Exchange. My settings delivers the mail to the
Exchange Mailbox, but then I have a rule to move it to my local PST
A problem started occurring recently where when I accept/decline a
meeting from the PST inbox, it doesn't update the status on my
Exchange calendar (the meeting is there, but the status didn't
change). It only updates the status on the PST calendar. (I think if I
accept/decline the meeting directly on the Exchange calendar, it
works; it only fails when I accept/decline from PST inbox).
What's strange is I've had this setu...Why does it multiply my 'sum' by 17?
Ok. I am working with a select queury and all I am trying to do is sum two
numbers in a column together that share the same 'queue'.
For some reason it's adding the two numbers and then multiplying by 17 for
Any ideas? Thanks for your help.
Post your SQL.
Build a little - Test a little
"Love Buzz" wrote:
> Ok. I am working with a select queury and all I am trying to do is sum two
> numbers in a column together that share the same 'queue'.
> For some reason it's adding the two numbers and then mul...Exchange calendar
I would like to know is it possible to add my Company's
holidays on exchange 5.5 calendar at the server level so
that everyone in the company can find?
This would be a job for the Public Folders section. Very easy to do.
Create a calendar folder in the Public Folders, set permissions on the
folder and add dates to it. Now, everyone with permissions can see it and
only those with edit permissions can change it.
"ray3d" <email@example.com> wrote in message
> I would like to know is it possibl...Outlook Calendar Appointments
When I create a CRM Appointment and invite an attendee who is also a
MS CRM user the appointment does not go into their outlook calendar
until they have accepted the invite. But what about if they are out of
the office and therefore cannot accept the invite?
I want it to work like an outlook appointment. This way inviting an
attendee will tentatively put the appointment in their calendar until
they accept the invite. Does anyone know of a way to achieve this?
The problem is, the actual synch to Exchange doesn't take place until the user
acts upon the invite ...multiplying
if I have two columns A and B. A is filled with numbers that I want to
multiply by the same number and have that total fill B. But I want also to be
able to change the number and have all the totals update....how?
Can't be done (without a lot of programming). This is not how Excel is
designed. Spreadsheets have lots of columns. Simply put the result of the
multiplication in column C.
"wineforyou" <firstname.lastname@example.org> wrote in message
> if I have two columns A a...Add holidays public calendar??
How can you add holidays to a public calendar? When I add
them , it goes to my personal calendar, not to the public
Drag and drop from your Personal Calendar, changing the View on your
Personal Calendar to Categories makes this process easier
"ronmont" <email@example.com> wrote in message
> How can you add holidays to a public calendar? When I add
> them , it goes to my personal calendar, not to the public
> Any ideas?
> Ron Mo...Publishing Outlook Calendar
Question: How many days does an Outlook Calendar remain available through
Outlook 2007 or Outlook 2010 Beta, before the subscribers start having
problems getting Calendar Updates?
Scenario: Person who shared the Calendar gets sick and doesn't update the
Calendar for over 3 days or connect to the Server.
Now it is like every time I open Outlook, I need to enter my Username and
Password to download the information.
Does the Calendar get remove after a period of time?
No, it doesn't get removed, but there was a problem with the pu...Resizing the delegated calendar screen
An associate has been given delegate authority to her
supervisor's calendar. This associate use to be able to
open her supervisor's calendar full screen. Now, the
calendar is always half size when opened. Is there a way
to get it back to full screen? Help!
Maximize button not showing up?
Collin Jew wrote:
> An associate has been given delegate authority to her
> supervisor's calendar. This associate use to be able to
> open her supervisor's calendar full screen. Now, the
> calendar is always half size when opened. Is there ...Turn off calendar background colors
Can anyone tell me how to turn off the background colors in Outlook 2007
I have appointment items that are categorized and so carry their respective
color, whichis what I want, but I don't want the whole day colored that
color as well.
tools, options, calendar options to change the color.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email: