Public Calendar items not showing up
One of our users is not able to view any data any public calendars. This
just started a few days ago. He has owner permissions and I've removed and
added him with not luck. It doesn't show any contacts. Any ideas? Exchange
2003. Outlook 2000. For testing, I created a profile with his account on my
PC (Outlook 2003) it show blank also. Thanks
he can see the folders, but not access any of the data in them?
Susan Conkey [MVP]
"Conley" <Conley@discussions.microsoft.com> wrote in message
> One ...I am using Excel and have made an error.
I am new to Excel and am imputing names and addresses. I have made an error
and want to undo, but the undo arrow will not work. Is there any other way I
can undo something I have done within the program?
If CTRL z (or Edit | Undo) don't work then the only other 'undo'
option would be to close the file without saving changes and open the
last saved version. Kinda drastic but I've done it on occasion.
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <77D9E12D-235...using fiscal year calculations in a formula
I have a fuel intake sheet i have to take care of. I can figure the calendar
year easily but i don't know how to figure in the fiscal year. The book
consists of the following:
date, type of fuel, amount, price (a,b,c,d)
What I need is to find the total of unleaded during the fiscal year plus
total of diesel during fiscal year.
In the calendar year i'm using the formula:
=sumif(b:b,"u",c:c) for unleaded
=sumif(b:b,"d",c:c) for diesel
I'm hoping this isn't too confusing.
Any and all help is truly appreciated.
=3DSUMPRODUCT((...An additional quantity of 1
A GP 10.0 Mfg client is seeing, in purchasing reports, where an additional
receipt of a quantity of "1" for an item is being received. This quantity is
in addition to the quantity that the client ordered through purchasing.
Is Manufacturing MRP generating this order for this additional quantity?
The only other area of Manufacturing that I can think of where an additional
quantity could be generated is in the Fixed Quantity field in Bill of
Materials. But, that field is showing 0.
Are there any other setups that I need to look at to determine where this 1
is coming ...How do I set up payroll for 1 full time and 1 part time employee?
You have probably not received an answers because no one will know exactly
what it is that you want. For example do you want it to work out the number
of hours worked, pay rates, overtime rates, calculate the tax due etc?
The way that these newsgroups work is for you to decide what you want to do
and then ask a specific question about how an individual problem can be
solved so decide what layout you require and then you can ask individual
questions. The following site contains hints and suggestions on how new
posters can best post to receive answers. For example some people do not
like t...Cannot remove last 5.5 server
I need some guidence in removing the last 5.5 server. We migrated to
exchange 2003 with out any problems, we moved all the mailboxes and public
folders to the new 2k3 server.
I removed the ADC prior to reading the KB article that shows how to remove
the last 5.5 box, which states that after I delete the 5.5 server I have to
force replication of the config_CA in order for the deletion to replicate.
My question is should I just install the ADC once again or can I remove the
server without affecting Exch. 2k3 using ADSI Edit (KB 328668)?
I need to remove this box but I am nervous...Publisher security #2
Can I password protect Publisher documents like Word documents so others on
network can't open? Read-only will not help as I do not want people to be
able to print or resave to their folders the documents that I create.
Mary Sauer MSFT MVP
"Betty_K" <Betty_K@discussions.microsoft.com> wrote in message
> Can I password protect Publisher documents like Word documents so others on
> network can't open? Re...Budget will not show correct mortgage.
I've entered my budget several times in M04, but it always has a Special Debt
section of $1400 dollars that I did not enter. It also shows that my house
payment has no money allocated to it. In short, I'm overbudget on my house
payment and $1400 dollars below budget on a Special Debt that I don't
recognize. From what items does M04 assemble this Special Debt? Also, why
is my house payment missing from the final budget?
"Jim7054" <Jim7054@discussions.microsoft.com> wrote in message
> I'...Search Inactive Contacts and add a button to show Inactive Contact
I have a CRM 3.0 and can't search "Inactive Contacts" in contacts. The only
way to search Inactive Contacts is through an Advance Find and it takes way
too much time and hustle. I also suggest to add a button next to "More
Actions" button or add a bar in the contact view within the account, this way
we can just click a button to view associated inactive contacts. Do you know
by any chance MS will consider this option in next version or add to the
current 3.0 version? I am sure I am not the only one who is asking about
this. This is very important for my...columns #2
How come when I sometimes open Excel.. the columns are
headed with numbers and not letters? How do I stop this
"Jon" <email@example.com> wrote in message
> How come when I sometimes open Excel.. the columns are
> headed with numbers and not letters? How do I stop this
> from happening?
Tools > Options > General tab, uncheck R1C1 reference style.
IIRC this is a setting that is taken from the first file opened. So,
anytime this happens, change the setting given by Anon,...i want 2 add a word to the start of every colum in excel
i have imported some a spread sheet, and i want to edit it and export it. the
problem is i want to add "alarms\" before the txt in a colmun
there is about 300 rows in the column so it would take to long to type
one method is to use a helper column, insert a blank column to the right of
your data (i'm assuming your data is in column A and the new column is
in B1 type
move the cursor over the bottom right corner of B1 until you see a +
and then double click, this will fill the formula down the column for you
now s...12.1.1 Edit-and-save custom dictionary confusion
I just followed the Word/Help directions for editing my custom dictionary.
Below my signoff is what I copied from Word/Help on how to edit:
But it's unclear which format to use for converting the custom dictionary
and then exactly how to save.
I tried a couple different options, including in Mac format for converting.
I also tried command-S and save in .dic after deleting some words and after
having it open a text file containing some words I wished to add.
When I logged out and back in, it was either as if I had made no changes in
several attempts to edit or, in my very last attempt, ...Caching a half-million rows into a .xls?
Just had a brief walk through of a monster .xls (about 50 megs) that caches
about 500,000 lines of data and does various presentations of it.
I couldn't find any way to actually see said data - but I'm taking somebody's
word that it's there.
Anybody have any idea how that might have been done?
It might be the beta of next excel version (Office 2007 for now but might be
2008 before it arrives)
it has 1 million rows and about 16000 columns. Otherwise they need to
portion out the data over multiple sheets
http://nwexcelsoluti...Buy 2 get 1 50%?
Just a quick question: I am trying to set up discounts in RMS... I would
like to use the Mix and Match feature, but I need to do a percentage discount
on the item as opposed to a fixed cost discount(last I tried RMS did not
allow the % character in it's string value). I need to have items
automatically get discounted as they are added to the line, so don't want to
Shift-F3 if I can avoid it. Thanks.
The only way to do this would to use a custom discout addon. Below is one of
the ones that are available.
http://www.newestech.com/POS/RMS/StoreOperations/Mix&M...GP Security Report that lists edits made beyond most-recent
During a GPUG.com webinar discussing GP v10 security earlier today, a
participant asked if there was a report that listed all modification dates
and the user who made the modifications.
For example, in SY09100 (Security Roles Master), there are two fields in
this table, MDFUSRID & MODIFDT, which record the User ID and Date for the
most-recent edits to a Security Role. The participant indicated that he was
often asked by his auditors to show ALL edits by date and User ID over a
period of time so that the edits could be investigated by the audit firm to
comply with regulations (mos...Activity Roll up
I was just wondering if the activity roll up within an account includes
activities created in custom entities which are related to that account?
If not, any ideas on how to do this? Help please.... :(
Activity rollup in V3.0 does not support rolling up from custom entities.
Thanks for your suggestion. We will consider this feature for a future
release. An Issue has been entered into our tracking data base.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2005 Microsoft Corporation. All rights
reserve...we will made the payment after the work is fully done
...can i wrap rows to form multiple rows per row to fit on 1 sheet?
i have a worksheet with very long rows (a to cf). For printing i would like
to wrap the rows to fit on a single page, and then seperate each set with a
space. I would also like to wrap the headers too, of course. is this
Say you're creating 10 columns per new row.
So it kind of looks like this:
$A$1 $B$1 $C$1 $D$1 $E$1 $F$1 $G$1 $H$1 $I$1 $J$1
$K$1 $L$1 $M$1 $N$1 $O$1 $P$1 $Q$1 $R$1 $S$1 $T$1
$U$1 $V$1 $W$1 $X$1 $Y$1 $Z$1 $AA$1 $AB$1 $AC$1 $AD$1
$AE$1 $AF$1 $AG$1 $AH$1 $AI$1 $AJ$1 $AK$1 $AL$1 $AM$1 $AN$1
$AO$1 $AP$1 $AQ$1 $AR$1 $AS$1 $AT$1 $AU$1 $AV$1 $AW$1 $AX$1
$AY$1 $...changes made but how do I revert !
When I deleted messages they used to dissapear straight away. Now when I
delete a message it has a strike through line but the message remains,
although it dissapears after I close outlook. I should also add that I use
SPAM Inspector but I think this is an Outlook problem caused by some
changes. the moral here is change one thing at a time !
Any ideas from anyone. email address required remove to be removed !
Are you using an IMAP account?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.co...Excel cell formatting #2
Is it possible to formal a particular group(s) of cells
such that all numeric entries are always expressed as
negative e.g an entry of 150 will be reflected in the cell
You can use:
Format > Cells > Custom Format
Type the string -#
But remember that this only "looks" negative. It's stored as a
Also, if you type in -150 you'll get --150 unless you use the format
Here, the positive entries get formatted with -150 and negative with
It'll confuse most users and I'd look for better approaches t...How do I eliminate 1 bar on the bar chart?
Hi there, I have this question:
I was sent a spreadsheet with all the bar charts. Data are not present
and data link is broken. Now I want to eliminate useless bars and only
leave out useful bars on the bar chart. I tried to select the bar I
don't want and delete, but it will delete all the bars. Can someone
teach me how to just delete 1 or 2 bars from the bar chart? Many thanks
charts typically only show visable celll data. the easiest way is to go to
the data sheet with the data and hide the column or rows associated with
>...Calculating Difference Between Two Dates Using Only Year
I'm using Excel 2007. I'm trying to calculate the Age at Death when given
the birth and death years.
I tried using the =DATEDIF function, but 2007 doesn't seem to support it.
Then I tried =YEAR(C3)-YEAR(D3), and you can see the results below. I think
it's because I entered the years as text, but when I tried to format the
columns for the date, I couldn't find a format that would let me list ONLY
the year. I had to have a month and/or day too. I'm not an excel expert, so
I'm probably missing something fundamental. Any help?
Surname Given Nam...Why user can use the last two passwords log on exchange server
The environment: Windows Server 2003 Enterprise with sp1 + Exchange Server
2003 Enterprise with sp1
If user change the password via iisadmpwd, and the user can access the mail
via OWA or Outlook with the last two password. But if i enable the Form
Authentication, user must type the lasted password to access the mail via
OWA, but Outlook also can use the last tow passwords.
The only reason the user would be able to use the last two passwords would
be that there is a delay in replicating the password change. When a user
changes a password (in any way, not just through OWA) the change is...CRecordSet #2
I'm using a class derived from CRecordSet. I Open the record set and read in
all the records recording their bookmarks. When something changes I use the
bookmark to update the database. The problem I'm having is when I want to add
a new record (AddNew followed by Update) and I go to get the bookmark (using
GetBookmark) I get an "invalid cursor state". There is a good chance the
dataset was at EOF before the AddNew. I tried preceeding the AddNew with a
MoveFirst but that didn't change anything.
Any idea how to deal with this problem?
PS: Keep in mind that a Reque...Filtering columns to show specific text only
I have a column in Excel XP with entries such as the two below:
CCMAIL:Simpson, Bart at
A AND O HN;o=NHS HEALTHCARE TR;s=Simpson;g=Bart;
SMTP:Lisa.Simpson@springfield.nhs.uk%X400:c=GB;a=NHS;p=NHS A AND O HN;o=NHS
HEALTHCARE TR;s=Simpson;g=Lisa;%CCMAIL:Simpson, Lisa at
What I need to do is filter these so only everything between <SMTP:> and the
first <%> symbol after that is shown. For example, the above two need to