excel viewer #2
Won't microsoft provide a simple, small and fresh Excel Viewer?
Version 97/2k is obsolete, using the 100% of processor time
and simply: it's not good.
I think not everybody buys Excel and Office so there should be
always fresh viewers (like Adobe Acrobat Reader, etc)
"on" <email@example.com> wrote in message
> Won't microsoft provide a simple, small and fresh Excel Viewer?
> Version 97/2k is obsolete, using the 100% of processor time
> and simply: it's not good.
> I think not everybody buys ...Splitting Y-Axis into 2 for a line chart
I have a bunch of data series that I want to chart using a line graph with $
on the y-axis and time on the x-axis. The trouble is that about half of them
have relatively low y-values (between 0 and $100) whilst the rest have high
My question is: Does anyone know of any way to manipulate the y axis so that
it ues a scale of, say, $20 for the 0-$100 section, and then "jump" to $600
(with zig-zag or something on the y-axis to tell the user that the graph is
non-continuous) and continue the chart there? Otherwise the scale just
becomes too large or too s...How to choose which account to send mail
I have 2 complete different accounts on my Outlook; one for work and the
How do I choose which account to use when sending mail. Sometimes I send e-
mails from my private account and other times from my work account.
Your advice will be much appreciated.
On Feb 7, 11:07 am, Deon <REMOVEd...@REMOVEsincro.co.za> wrote:
Before sending the mail u can check in program
"Application..Session.CurrentUser.Address" which will return the mail-
id of the current configured account.(which is activated).
May be this is yo...FW: Use this security pack from MS Corporation
Content-Type: multipart/related; boundary="lohgixbpannvck";
Content-Type: multipart/alternative; boundary="zgzowyecznv"
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to maintain the security of your computer
from...Using wildcards w/ sumproduct
I'm not familiar with wildcards in formulas, and I can't seem to figure
out exactly what to do here.
If the first 3 letters in cells of column A contain FPC, then sum
corresponding rows in column P, then by the total number of cells in
column AT where the first 3 letters are FPC.
Any assistance is greatly appreciated.
if I understood you correctly try
=SUMPRODUCT(--(LEFT(closed!$A$3:$A$20003)=&qu...Outlook using RPC over HTTP and Passwords
We have implemented mandatory password changes every 60 days and the remote
users with Outlook over http and not given an opportunity to change the
password when it expires. After the 60 days they can't get in and I need to
change their password on the server.
Is there something I need to do? or fix? VPN users are being prompted to
change their passwords and can change them themselves.
Can they change them from OWA?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/...How Message Format work for POP3 account?
I created an account in active directory and created mailbox for it. I want
this account to have only POP3 access. Because the POP3 client is some old
one, I need the message body received by this account be sent to POP3 client
in plain text format.
So, I went to "Exchange Features" tab (we are using Exchange Server 2003) in
this account's properties window and configured the POP3 properties as
Uncheck "use protocol defaults", select "MIME" and select "Provide message
body as plain text"; the default character set is "Western European
(...How can I find out which apps are using .NET and which not?
I appear to have three versions of .NET (2, 3, 3.5) with their
associated special packs.
How can I find out which apps are using .NET. (Please, no 'cut-one-out'
method, I do not want to uninstall and see what has stopped working.)
I am aware that the different .NETS are individually and separately
usable by different apps - my questions is what app uses which?
Thanks for any pointers
> I appear to have three versions of .NET (2, 3, 3.5) with their
> associated special packs.
> How can I find out which apps are using .NET. (Please, no 'c...add values using vlookup over multi sheets
I have a workbook which contains about 20 worksheets.
In sheet1 I have a list of numbers which could be also on the other 19 sheets.
What I need to do is look at each of the other 19 sheets to see if they have
the number which is on sheet1 and if so I need to get the numerical data in
the 5th column to be returned and added together.
sheet1 a1 = 2001
sheet4 a5 = 2001 e5 = 2
sheet6 a21 = 2001 e21 = 5
therefore sheet1 b1 = e5 + e21 = 7
Hopefully someone could help me.
=SUMPRODUCT(SUMIF(INDIRECT("Sheet"&ROW(INDIRECT("2:20"))&&q...I Need to divide all cells in rows 2 and 3 by 100
I need to divide all cells in rows 2 and 3 by 100. Anybody know a way to do
put 100 in a cell, copy it, select row 2 and 3, do edit>paste special and
"Brent E" wrote:
> Merry Christmas,
> I need to divide all cells in rows 2 and 3 by 100. Anybody know a way to do
Put "=1/3" in a cell and then select it, copy, then select rows 2 and 3 and
edit | paste special | multiply.
"Brent E" wrote:
> Merry Christmas,
> I need to divide all cells in rows 2 and 3 b...1 Mailbox
Here is the situation:
Main Office in Country A (Exchange 2003)
Remote Office in Country B (Exchange 2003)
I have several users that travel between country A and country B. We
have an exchange server in both offices. The complaint is that when
the users get to Remote Office in Country B because their profile
points to Main Office in Country A, their outlook session runs
We have temporarily put in a measure that when they travel from
Country A to Country B that they are instructed to log into a seperate
profile that points them to the exchange local to where they are.
When travel a...Using the Google Calendar .net API from an Access application
I have a scheduling/calendar application in access. I also use Goggle
calendar. Would it be possible to use .net from Access to send my schedular
entries to my Goggle calendar?
OP <OP@discussions.microsoft.com> wrote:
>I have a scheduling/calendar application in access. I also use Goggle
>calendar. Would it be possible to use .net from Access to send my schedular
>entries to my Goggle calendar?
It might be possible but you'd have to do a lot of digging through the
Google calendar documentation looking for the various APIs and
figuring out how to execu...Sub report won't show lines using PrintLinesClass
I'm using PrintLinesClass in a sub report, which works well.
Opening the Parent report shows also the lines in the sub report
correctly, in preview view, but not when printing the report.
Is there any way to fix this problem?
Thanks in advance for any hint!
Try increasing the resolution(quality) setting of your printer driver.
Change the color of the lines from Black to a blue or dark grey color.
Increase the thickness of the lines via the DrawWidth property.
Access Code, Tips and Tricks
Please respond only to the newsgroups s...FWD: Use pack
Content-Type: multipart/related; boundary="ocmbostjnqamcd";
Content-Type: multipart/alternative; boundary="wtcazseafbqr"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to prote...prevent blank cell #2
How do I prevent users of my workbook from making a cell blank? I want them
to be able to edit it so have left it unprotected but I donot want them to
be able to leave it blank. It looks as if the Data Validation command should
do it, but I can't get it to work.
Your repeat post appears as a reply to the thread in my browser. As a
result, I almost didn't read your post on the assumption that your
question had already been answered. I suspect many others did ignore
your post for the same reason.
Assuming that you know how to set up the validation condition (uncheck
"I...Account Lockouts from Exchange?
I'm having some difficulty, and I'm hoping that someone out there has some
insight. I have attached a lot of materials to this post, so if I refer to
something, and you don't see it right away, just scroll down.
Last week, I implemented an account lockout policy on our Windows Server
2003 domain. Almost immediately, my account was locked out. I set the
account lockout threshold to 5 attempts, over a 30 minute period, and to
lock out indefinitely.
I assumed that I had logged onto someone's machine and they had then typed
in their password and locked me...CRM 1.2 exam for customers
Is certification available for customers or is this only
available for partners. I've read many of these postings
in regards to the exam and many people mentioned getting
the study material straight from Microsft rather than take
the courses...how would a customer go about getting the
Yes, starting July 1, 2004, customers will be able to take a Microsoft
Business Solutions exam at Pearson VUE or Prometric testing centers.
"Jen Selmeyer" <firstname.lastname@example.org> wrote in message
>...Cash Flow Doesn't Display #2
Any ideas on how to get Cash Flow to start displaying? (Money 2007 Deluxe)
I've followed the KB Q312814 article doing one run of manual deleting each
Bill -- didn't work and then the mass Bills delete under repair -- didn't
work either. Even though the Bill summary is empty, Cash Flow screen doesn't
come up. I have run through the Standard Repair. (Don't have/use Budget or
Debt Reduction) Any help would be appreciated.
...setting up cash portion of account
One of my money accounts has a money market sweep account. How do I change
money so that all cash transactions get posted to the seep account as opposed
to the "cash" account.
Your investment account and your sweep account should not be two
separate accounts in Money. All cash transactions in the single
investment account are swept periodically (daily?) into the sweep
investment (not an account). Treat the sweep investment like you would
any other investment in the account. When choosing the type of
investment from the investment wizard, choose money mark...how create project with mfc #2
thank you for reply,
i'm on way learn , i have book on visual c++, but it is too diff j# an
c++ in win api ... and mfc
thank you very much, i take your recommend...
Posted via http://www.codecomments.co
...XML Serialization problem ( ver.2)
I have some XML Serialization problem.
I searched Internet and found some good info but still can't resolve
I have next situation:
I have solution contains 2 projects: Proj1 and Proj2.
Each project compiled to dll.
In Proj1 contains Class1
And Proj2 contains Class2.
Class2 has reference to Class1.
I want to XML serialize Class2.
In order to do that I added attr: [XmlInclude(typeof(Class1))] before
It's compiled but when it's running it throws exception something like
"File or assembly name Proj1, or one of its dependenc...IRS Schedule D & Schedule D-1 prep.
Any Spreadsheet / template (Excel97) to prepare IRS
Schedule D & Schedule D-1?
I need to file back tax returns (1995 & 1999!!!) and I
need to prepare Schedule D & D-1.
I have thousands of stock trades on my spreadsheet.
Anything out there (free preferably) that can import this
and prepare the Schedules?
MANY MANY Thanks!!!!
>There may be something here. The site has tax schedules
>-----...2 WITH statements
Doing this in SQL 2005. How do you connect 2 WITH statements. I'm trying
to use (;) or (,) and neither is working. What am I doig wrong. I'm just
tyring to get the second WITH table to show up.
Thanks from a newbie
WITH MtdCount(TraderID, MTD)
(SELECT Commission.TraderID, COUNT(Trades.Broker) AS MTD FROM Trades
RIGHT OUTER JOIN Commission ON Trades.Broker = Commission.TraderID WHERE
(Trades.TradeDate >= DATEADD(mm, DATEDIFF(mm, 0, @TradeDate), 0)) AND
(Trades.TradeDate <= @TradeDa...Recipient Policy not working #2
I recently moved our Exchange server to a new server by restoring the
information stores from backups. Everything seems to be working fine, but
now when I add a new user/mailbox I have to manually enter an SMTP address
for them. The recipient policy isn't propogating out to new users like it
Could you check the Recipient Update Service via Exchange System Manager and
ensure it is pointing to a valid Exchange server and Domain Controller.
This posting is provided "AS IS" with no warranties, and confers ...CRM usage reports #2
What would be the best way to generate CRM usage reports, like
- which users/business units make heavier use of the CRM
- what are the crm's "most visited" areas
- what are the peek hours or seasonality patterns in usage, etc.
These reports could be used to help make decisions about hardware upgrades
in advance and things like that
Should these reports be based on IIS logs, SQL Server ones, or something
I think the CRM IIS log would be the best for your analysis needs.
Darren Liu, Microsoft CRM MVP
On Apr 2, 5:34=A0pm, v...