Sorting should be done on more than one column
Currently views can be sorted according only to one column. It would be
better to sort on more than one column like in excel, first sort by A, then
sort by B etc.
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/Businesssolutions/Com...Workflows not starting automatically with one user
I am having an issue where workflow rules that were created and worked fine
in 1.2 are not start automatically in 3.0 for one user (me). I can manually
start the rule and it's fine and others can do the same action that should
start the rule and it works for them..just not me.
My research tells me is probably related to me being an administrator and/or
being an administrator when I created the rules.
I've also been told to look at the user that the CRM workflow service runs
as and make sure that service account has the correct privaleges-which it
I am just not sure w...Slightly OT: Anyone ever used the IDiscMaster interface?
I am getting "class not registered" errors on CoCreateInstance even though
the service is up and running on my machine, and I have the Platform SDK
(ergo, "Imapi.h" where the CLSIDs are defined.)
Doh, guess what? LOL, IMAPI runs as a local server executable. So, if you
want to use it, specify LOCAL_SERVER instead of INPROC_SERVER...
Sorry to have wasted everyone's time.
"WTH" <email@example.com> wrote in message
> I am getting "class not registered" err...Recently moved home. Using dads ISP. Can't send or recieve email
Recently moved from Austin to Kansas City. Currently using my fathers ISP for
internet and email access. Need help on how to send and receive emails
through outlook 2002. Can I just creat a new account with my own personal
user name and password?
Boomerang <Boomerang@discussions.microsoft.com> wrote:
> Recently moved from Austin to Kansas City. Currently using my fathers
> ISP for internet and email access. Need help on how to send and
> receive emails through outlook 2002. Can I just creat a new account
> with my own personal user name and password?
With the ISP? You...Multiplying the number in one cell and providing the product in an
I've never set up a formula before, not even the most basic. I need help and
I'm not sure if its entirely possible. Please let me know.
Labor Hours Labor Cost (95/hr)
I need to be able to enter in the number of hours in one cell (under labor
hrs) and have those hours multiplied by the cost ($95) and the product
displayed in the cooresponding cell (under labor cost).
Is this possible? If so, how?
1. In cell A2 I have put your 2 (your hours figure).
2. In cell B2 I have put ...Why when i have more than one workbook open and i want to save ch.
When i want to close only one workbook all of them closes and then i have to
reopen the ones i want
at the top right of the screen do you see two X
- the top one should close the application and all workbooks
- the bottom one should close only the active workbook
does this work for you?
if not, does using File / Close from the menu work?
"Jaykhi" <Jaykhi@discussions.microsoft.com> wrote in message
> When i want to close only one workbook all of them closes and then i have
> ...Cannot delete one message in Windows Mail
A message fron Sen Feinstein to an individual copied to me can not be
On Wed, 27 Feb 2008 13:43:18 +0100, John Kirby wrote:
> A message fron Sen Feinstein to an individual copied to me can not be
> deleted ?
You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
Please repost to the correct newsgroup for whatever program you are
using. I would suggest you include your Windows version number in the
Please respond only to this newsgroup.
I do not reply to personal e-mail
...Combine the contents of two cells.
I want to copy the contents of a cell and insert it at the beginning of the
text of another cell: ie I want to combine the text contained in two cells
into one cell. I can do it manually but would like to use a macro as I have
a lot of cutting and inserting to do!!
I use Office 2000.
Assume you want to combine cells A1:A100 with cells
B1:B100. In cell C1 enter this formula:
If you want a space between values:
Drag copy down to C100 or just double click the fill
Now, if you no longer need the data in columns A and B
select C1:C10...Using RANK Function
I need to rank 225 rows of data. Can I use the replace function so
D4:D229 appears in each cell? Thanks for the help.
Use $D$4:$D$229 as the range reference in your RANK function, and it won't change when you copy the
MS Excel MVP
"Skip" <firstname.lastname@example.org> wrote in message
>I need to rank 225 rows of data. Can I use the replace function so
> D4:D229 appears in each cell? Thanks for the help.
...Can't use links
Every time I try to click a link I get an error message "general failure.
the url was: "http....etc
Any idea what's going on? I can't even enable instant search or click any
links in my email. Always get the same error message (obviously with
different url info). I welcome your suggestions and thanks in advance. I
just recently upgraded from office 2003 and 2007 is awesome!
This appears to be a default browser problem. In the two cases I found by
searching, the problem was solved by setting IE to be the default browser;
in one case by using "Set Program acces...How to create a line chart with two X-axes in Excel
PLEASE HELP ME!!!!! How can I create a line chart with two X-axes in Excel?
select one of your data series and change axis to secondary. <chart><<chart
options><Axis> Select secondary x axis.
> PLEASE HELP ME!!!!! How can I create a line chart with two X-axes in Excel?
Hello, thank you for replying.
Which chart type would allow for 2 X-axes. The only chart type that I know
that allows for 2 axes is "Line Chart with 2 Y-axes".
For the above-mentioned chart, the option to designate a primary and
secondary x-axis is display...How to use MFC 4.2 with Visual Studio .Net
Hi! I have recently started using Visual Studio .Net in place of Visual
Studio 6.0. My application is an Active X control written in C++ with MFC
Is there a way I can force Visual Studio to use MFC 4.2 and not MFC 7.0,
since the application will be deployed mostly on systems with MFC 4.2.
I know I can use "static linking" but that will make the application large
and I am still adamant on using 4.2 libraries rather than 7.0 to be safe.
Thanks in advance for your help.
This question has started coming up a lot. The answer is simple: revert to VS6. ...Chart with two types of lines
I am plotting data from 2006 and now starting to plot data from 2007 in
a line chart. I would like the line from 2006 to be a solid line, and
the line from 2007 to be a dotted line. This is measuring the same
data, just in different years. When i try to add a different series,
the new line for 2007 appears, and the 2006 line disappears. I'm not
sure how I get both of them to appear at the same time. Any idea what
I'm doing wrong?
Have you checked Chart/ Source Data/ Series tab to see what you've got for
your two series?
It may also be worth thinking about whether it might be...Can I make a Cladogram using microsoft Excel?
I'm using microsoft offfice 2003 and was curious is there anyway I can make a
caldogram using the program? I know that it is possible to make a family
tree; however this is inifficient in depicting ancestoral progression of the
species- which would be better display with a cladogram. Any Help greatly
Maybe fernando cinquegrani's cluster or grafi examples may help.
It should be possible to construct a chart using a xy-scatter and
various charting tricks. But a lot depends on how you have this data
La...Changing data orientation from one sheet to another
On sheet1 the data is oriented vertically as
I'd like on sheet2 the data be oriented horizontally
A1 to A1
A2 to B1
A3 to B3
Can it be done? if so, how?
Copy the data from sheet1
Select A1 of sheet2 and paste special>transpose.
Note: cannot be done if you have more than 16384 rows of data in column A
Also, I think you have a typo at A3 to B3.........maybe A3 to C1?
Gord Dibben MS Excel MVP
On Sun, 20 Apr 2008 19:55:12 +0200, "Olga" <email@example.com> wrote:
>On sheet1 the data is oriented vertically as
>A...How attach a file in one cell
I'd like to know if it'll be possible attach a file (word, pdf...) in one
cell. I'm doing an Excel doc. and I need to put some instructions by doc.
attached. in some cells. Thanks!
In article <A23394A2-B804-4855-875A-7664B90F4F48@microsoft.com>,
How attach a file in the cell <How attach a file in the
> I'd like to know if it'll be possible attach a file (word, pdf...) in one
> cell. I'm doing an Excel doc. and I need to put some instructions by doc.
> attached. in some cells. Thanks!
Cells can contain...Delay in receiving SOME mail for one account
I have an exchange 2003 enterprise server with Windows 2003 enterprise
server. Out of the 30 employees in the company, only ONE has a delay in
receiving SOME of their e-mail (the president of the co). It seems to arrive
about a week later, but if someone else in the company was CC'd on it, that
other person will receive it. All the mail is filtered through Symantec Mail
Security and then through the exchange server. All the appropriate ports are
open. Do anyone have any ideas on what it could be?
How is the president's client (Outlook?) connecting? I suspect that th...backing up exchange 2003 using arcserve v11
i know that this may not be directly a problem with
exchange but i thought i'd post this anyway for anyone
who uses arcserve to backup their exchange.
i just installed brightstor arcserve v11 on my windows
2003 server. i'm using this to backup my exchange 2003
enterprise w/sp1 (installed on win 2003-this is a
separate server from my backup). i installed the exchange
backup agent on my exchange server and the client agent
for windows with no problem. i've created the brick level
account thru this agent eventhough i will not be using
brick level backup.
First of all when I click on the outlook live link it comes up with with my
student email account, with no password (It only remembers my address).
The actuall bug happens if I type some some characters into the password
field (any characters) and click "forgot your password" and then before it
loads click "sign in with a diffrent account". This takes me to the "forgot
password page" and if I click the back button my account with my "correct"
password is sitting waiting to be signed in with.
For now I can only get it working (the bug) w...Access not Installed on Pc, Are user still able to use application?
Not sure if this is the right group to pose my question about Using Access.
Understand that the normal way of using is User must have Ms Office-Access in
order to use the application.
As I had a fully operational application developed using Ms Office-Access,
but certain terminal in my company does not have Access installed.
Any suggestions, any one ? (Eg: I was suggested using Visuo software that
save as a .exe file to serve as a 'bridge' between User that do not have Ms
Access installed in their system and Access Applications that is residing in
Edis...Windows Mail removes attachment from one or more senders
Why does my Windows Mail on Vista remove attachments from messages from one
particular sender who has a different IPS? When my server downloads messages
to Windows Mail, I often get a message telling me, essentially, that
"Windows Mail has removed attachment which was 'unsafe.' I can go out to the
server and see the attachment, open it without any problems, but as soon as
I open my Windows Mail, that same message has had the attachment removed by
The attachment is not removed. Access to it is blocked by your settings.
If you clicked on that message...Excel 2008 bug
Operating System: Mac OS X 10.6 (Snow Leopard)
Open a blank sheet. <br><br>Enter a value with a dash in it - i.e., U1-1 <br><br>Excel will NOT allow you to set the series - it'll increment by 1 in the 'normal' direction and decrement by 1 in the 'reverse' direction. It will not allow you to set the series step whatsoever. <br><br>Oh the joy. Now I get to enter 256 fields by hand.
Well, what isn't clear is what you would have it do instead or how you're
attempting to get it to do otherwise. If...Values in multiple columns into one column
I have a spreadsheet with values in multiple columns
where for instance col A is blank colb or c or d won't
be...there will be something in one where the others are
empty. I need to create a column with all the values
together. Tried using the following formula but it
doesn't seem to work... the values are all dates..
=IF(O2=" ",N2,IF(N2=" ",K2,IF(K2=" ",J2,O2)))
Can anybody help!!
>I hav...Securing emails between two companies
I need to come up with some options on securing email communications
between two domains (companies) that are wanting to email data that
needs to be secured. There are HIPAA requirements that need to be
met. They do not want to share any other data at this point. Both
organizations are running Exchange 2003. They do share some
infrastructure and have their networks separated via VLANs. They both
have their own internet connections.
I am currently looking at setting up SMTP connectors. Am I going down
the right path, or is there a better option?
an smtp connector should work i...Install add-in using OCT
Is it possible to automatically install an add-in by using the OCT tool?
By that I mean, create an msp file with the tool and then run
the install from a command prompt.
Or put another way, I want to run automatically another msi file after
is finished installing.