2 Files Open In 2 Instances Of Excel
Hope someone can help.
I have a spreadsheet that contains userforms as navigation tools fo
that specific spreadsheet.
If I open a windows browser and try to load another Excel file whils
one of these Userforms is active, it does open the file, but behind th
This also then causes problems with the navigation of the buttons o
the userform, as the buttons tend to point t
Is there a way to set Excel to open all new files double clicked on i
the Windows browser, in completely separate instance of Excel? So tha
they would run separately and n...Help help ,help! OWA problem. 440 Login Timeout https://emilserver/exchweb/bin/auth/owalogon.asp?url=https://emailserver/exchange&reason=0
I installed Exchange2003 in windows 2003 server.
it runs well .
but few days ago, when I using https://emailserver/exchange to access OWA it
automatic change address to
and display below:
440 login Timeout.
exchange2003 other part is good. user can use POP3 and SMTP. so I don't
wan't reinstall all exchange2003 . I need find a tools or some thing can
reinstall or reset OWA in IIS .
who can help me?
Thanks A lot.
Does this help?
http://msmvps.com/cgross/archive/2004/0...Searching the Dumpster for all Folders and Users #2
Is there any way for an administrator to search all users dumpsters for
Any advice would be much appreicated.
...2 line and a column graph
Is there a way to get a graph that has 2 lines in it
(which read off the Y axis) and on the same graph have
columns that reads off a secondary Y axis?
And all these on one set of X axis?
The spread sheet is all set up but i can't find the
graph that i want in the wizard!
Create a line chart, right click on the series you want to show as
column, select chart type and choose column. Right click it again
select format data series, axis, and choose secondary.
One problem I've found with this kind of graph is that the legend entr
for the bar always defaults to the left o...Email Header #2
How do I print the email headers in Outlook 2003 automatically?
Woody Watkins wrote:
> How do I print the email headers in Outlook 2003 automatically?
I don't know of any way to do that - certainly nothing built in. What is it
you're trying to do, exactly?
...Outlook importing #2
I'm trying to import contact information from Excel to
Outlook and it says I need to install the SR-1 disk in
order to accomplish this task. I grabbed the disk and it
says that I need to find data1.mis?
Anyway, it doesn't work. Is there something I can
download to fix this?
...changing margins #2
Did I tell everybody here my computer crashed and I was without a
computer for 2 weeks? Well, I'm so frazzled and am going crazy trying to
print an invitation and can't get it to print far enough to the right. I
can't find where to reset the margins. Where should I look?
Take tow Valium and talk to us after you get things straightened out again.
(I'd be a wreck after two *days*!)
MVP Microsoft [Publisher]
"Erika" <email@example.com> wrote in message
news:mzcWg.9822$YO.firstname.lastname@example.org.....Business Portal 2.5 CD
I have emailed my VAR and was told that the BP 2.5 was on the 7.5 or 8.0 CD.
Another individual then sent me to an FTP link to download BP 2.0 but I
really wanted 2.5 because 2.0 does not work with 8.0. Does anyone have BP
2.5 and if so how did you obtain the CD?
I would like to know that as well. We had our Version 8 CD's before BP 2.5
was even released.
"Ann" <Ann@discussions.microsoft.com> wrote in message
>I have emailed my VAR and was told that the BP 2.5 was on the 7.5 or 8.0
> Another i...Vlookup with VBA #2
I need to do a vlookup in a VBA Macro for the values in column "B." However
the values in the Table Array of column "A" are the same. Can I combine a
Vlookup and an Offset ?
Column A Column B
Paid Vendor 1
paid Vendor 2
You might want to consider making the functions in the freely
downloadable file at http://home.pacbell.net/beban available to your
workbook. Then you could array enter into a multi-celled column
> I need to do a vlookup in a V...Ip address change #2
Is possible to change the IP address of an Exchange server!?
On Fri, 22 Dec 2006 10:49:06 +0100, "MMC [MCP]" <email@example.com>
>Is possible to change the IP address of an Exchange server!?
Sure. Be sure DNS reflects that change as well.
...SUM TOTAL #2
I need help with totaling a range of cells G12:G46. My problem is that not
all cells contain values for the formula in these cells so it is not allowing
me to do so. This is on a quote sheet and I would like to subtotal as I go,
can anyone help?
see your other post
Microsoft Excel MVP
"Chris" <firstname.lastname@example.org> wrote in message
>I need help with totaling a range of cells G12:G46. My problem is that not
> all cells contain values for the formula in these cells ...Mapping #2
Hello I am a newbie to Dynamics,
I am attempting transfer/duplicate information across from Lead when its
converts to an Opportunity.
I have selected the created attributes for Lead and Opportunity (both "Lead
Source") and then created the mapping. However when I come to publish the
customisation it still doesnt seem to work?
Would anyone know why this is?
Can you give some more details and write the attribute which you are
having problem in mapping under the lead and opportunity .
Lead (attribute)(dataType) ------------------------Opportunity
(attri...CAsyncSocket Listen Timeout
Good Afternoon Everyone;
I hope someone has come across this problem before. I am doing
some programming with CAsyncSockets and I am unable to find a way to
get the Listen method to timeout. Communication between my two
computers works fine and I can send and receive data no problem.
However I want to ensure that if for whatever reason one of the
computers goes down that the other computer does not sit there waiting
to receive data that is never coming. Currently all I can think of is
spawning a thread to do the counting for me, and then close my
listining thread through my new thread...Formsauthentication timeout and 2 login pages
My client wants 2 separate login pages for an ASP.Net app, one for
regular users, one for support staff. I am using the standard
FormAuthentication component for authentication. Is it possible to
redirect a regular user to one login page after a timeout, and also to
redirect an admin user to a different page after a timeout? The
loginUrl attribute of <forms> in web.config is read-only, and cannot
be edited at runtime.
In other words, can I do this:
Regular User -> Timeout -> Login.aspx
Support User ->Timeout -> SupportLogin.aspx
I want to format a cell to show a Upper case X just by clicking on it.
this would require VBA (using the Selectionchange event for example).
"Lee and Rebecca" <LeeandRebecca@discussions.microsoft.com> schrieb im
> I want to format a cell to show a Upper case X just by clicking on
Can you help me with this? I don't understand what to do from that web site.
"Frank Kabel" wrote:
> th...Disaster recovery #2
Recently my old NT 4 server croaked (running Exchange 5.0)...anyway to cut a long story short, I have the hard drive from the old server up and can access all the old files. I wish to migrate some information such as old emails and contact lists to the new Exchange 2003 server...but I don't know how to do so
Managing Foods, LLC.
You likely need to rebuild the Exchange 5.0 server and Exmerge the data.
Hope that helps,
This posting is provided "AS IS" with no warranties, and confers no rights.
Please d...Customizing -2^2
Shouldn't minus a squared number be a minus number? In Excel -2^2 = 4. To
keep it negative I have to write -(2^2). It's very easy to make mistakes
because I also work with Quattro Pro which works differently. Is there a way
to customize this in Excel so that -2^2 = -4?
In Excel the negation takes precedence over the power operator.
However, subtraction is a lower priority.
results in -4.
Does that help?
"Tim Walters" <timwalters@DROPTHISterra.es> wrote in message
> Sho...Roundings #2
The following is a sample excel worksheet from the month
end investment entries. It is fairly simple, 45% of the
total gain is deferred for tax purposes and the remainder
is the increase in unrealized gain for investments.
45.00% 19,483.73 8,767.68
45.00% 8,684.90 3,908.21
Proof Totals 28,168.63 28,168.63
What is interesting is that if you look at the numbers,
they do not add:
Column one is correct, but column is realli 28,168.64.
There i...Locking Formulas #2
Is there a way to lock a series of selected formulas without going
through and editing every individual one? This is very time
consuming. I have looked and I haven't found anything thus far.
What do you mean by lock and why do you have to
edit a formula to lock it?
You can select the whole spreadsheet, do format>cells>protection and clear
locked, then select all the formulas you want to lock and reverse that and
select locked, then protect the worksheet
<email@example.com> wrote in message
news:c5f3ad46-08f1-4498-bd80-2c73eb6...page breaks #3
I want to insert a page break "automatially" while or after creating
rows numbered 1 to 500, in order to number 500 prewritten pages. Is
I think the answer depends on what you mean.
Do you want a page break after each row of the 500 rows? Seems kind of odd...
XL can change the print range depending on what cells you've used. If you type
something into those cells, then do a print preview, you can see where these
natural page breaks occur.
randall martin wrote:
> I want to insert a page break "automa...CColorDialog #2
I am trying to work with the CColorDialog in an MFC app and everything is
going fine, except I would like to change the title of the dialog so that
instead of "Color" I make it say what I want it to say. Seemed easy enough
to do, but no. Not much info on the web unless I am searching for the wrong
kinds of info.
Of course, it derives from CWnd, so I tried SetWindowText(), but that failed
and I assume it is because the handle to the color dialog doesnt exist until
you call DoModal(). Thus the call to setting the window text fails because
there is no window.
So, what are th...vlookup with 2 columns?
I am doing a VLOOKUP which is working nicely, but I had this idea where the
user could specify in the sheet data from 1 column and then data from
another column and where you have both in the row I would get other data in
the row. Is there anyway of doing that?
E.g. if the data was like I have laid out below and the user specified A1
and X2 I could get at the data 20 or 21 but I wouldn't want the row before that.
A1 X1 10 11
A1 X2 20 21
B1 Y1 11 22
B2 Y2 22 33
If the data to return is numeric as is demonstrated in your sample *and* the
combination of A1+X2 is un...Problem Login
I had the server crashed during log in of sa.
I'm tryin to log in to fabrikam but it specify that sa is alleady loged in.
Trying to delete the previos session I get the table of user id's empty
without an options to delete the sa session from Fabirkam.
Can you get into the Dynamics DB Activity table in the SQL Server Enterprise
Manager? Take a look in there and see if that has any users still logged in
from the crash. As long as everybody is out you can delete the all the users
out of the Activity table.
Check the tempdb database specifically t...RMS 2.0 and PC Charge
Is anyone using PC Charge Pro with RMS 2.0? I haven't been able to get any
answers from Verifone as to certification with RMS 2.0. Does PC Charge Pro
support the AVS function in RMS or does it do it itself?
I'm changing Merchants and the new one requires using PC Charge Pro.
Funny thing... I have basically the same question. Our MS VAR told me to
check with PCCharge (Verifone) .
VeriFone told me "They (MS RMS) test their versions with our software and
keep a list of which is compatible.
If you are using the newer version of RMS then I would say 5.7.1I SP...threads #2
I have a server/client application that communicates using threads. The
server class uses a while loop inside a thread to wait for new connections
in accept state, like this:
var a = new var( );
while( (server.Accept(connection)) )
I have declared a variable (var) right before this loop which uses memory.
I want to free/delete this variable at the end of the while loop, but the
control never reaches there.
How can I make sure that this variable gets deleted before the server side
Jessica Weiner wrote:
> I have a server/client applicatio...