Array formula #3
Hi - I was wondering if someone could tell me how to do
the following calculation:
In sheet1 called 'Eigenvectors' I have a 75 by 75 matrix
In sheet2 called 'values' I have a 75 by 2000 matrix of
In a third spreadsheet I want to create a matrix of the
same dimensions as 'values'. each value in this matrix
should be calculated such tthat:
rsA3*valuesC2,...E...Icon from custom Entities are gone after rollout update 3
after i applyed rollout update 3 all icons are now a red X, i can update the
icons, then when i try to publish the icons it say that a error has occured,
can some one help please
...Counting text cells #3
I have a range of cells A25:A256 that contain text entries of various types (doesn't matter). How do I get it in cell A258 to give me a total of cells that have text in them within that range 25:256
"Jessica Walton" <email@example.com> wrote in message
> I have a range of cells A25:A256 that contain text entries of various
types (doesn't matter). How do I get it in cell A258 to give me a total of
cells that have ...Defrag #3
The PRIV.EDB on my Exchange 5.5 server has grown to 35gb. This server was the main server but I have since built a further two Exchange servers, added them to the site and moved mailboxes off it.
This server is now primarily used as a Bridgehead with connectors to other sites, Public Folders and also hosts the Internet Mail Service
The backups are still backing up the information store of 35gb, which I gather will only reduce after a defrag is performed. I am worried that if I perform the defrag, Internet and Intersite mail will stop. (Am I correct to assume this?
What else can I do...CRM 3.0 and Outlook2003
Someone can help me to fix this problem?
A couple days ago, the CRM's botton which being addin to the outlook is not
working, and error messages are shown up when outlook is starting up:
"(There is a problem communicating with the Microsoft CRM server ...... An
error occurred loading Microsoft CRM functionality. Try restarting Microsoft
Outlook. Contact your system administrator if errors persist......)" . The
web-accessing for CRM is working.
How can I fix this problem?
Thanks a lot for your help.
...Chart Question #3
is it possible to create a chart, skipping columns or rows
I need to creat a chart using data from every other column and another
using data from about every 5th row
Any help appreciated
I'm open to correction on this, but I believe the best way to do this
(assuming you don't want to delete the in between data, and resort the
columns somehow) would be to create a macro that copies the data you want
into the right format (probably on another sheet) and make the chart from
Something along the lines of:
dim NewSheet as worksheet
dim OldSheet as w...Mail Relay #3
In Exchange 2003, is there an easy way to tell if Relaying is working? I
have a server IP added to allow relaying, and the mail is not delivered to
the outside address. The question is, is it not relaying, or is the problem
with the sending server?
Do you receive any NDR?
Did you check the SMTP queues?
Blog "subject: exchange"
"Ed" <firstname.lastname@example.org> wrote in message
> Hello all...
> In Exchange 2003, is there an easy wa...ADO connect mysql
I want to use mysql as database,and work on the datas through ADO in the
excel. so I get exchange the datas with Excel and mysql. This is best way for
my works I can imagine this moment.
Please help me to provide me code how to establish connection from Excel to
"Li Jianyong" <LiJianyong@discussions.microsoft.com> wrote in message
> Dear Sirs,
> I want to use mysql as database,and wo...Solver add-in #3
Hi, I've been fiddling with the Solver Fantasy Football example on here.
In my example (it's using soccer league data - but similar except
there's no need for the team data on rows 110-136). I've added an extra
column for each players club but I can't work out how to add a
constraint such that I restrict the numbers of players from any one club
to only 2?
I hope that makes sense - I've got the solver to pick the team with
maximum points but it has 5 players from the same club. I want to
restrict it to ...ADO
Can I use ActiveX Data Objects(ADO) with any ODBC compliant database to access data?
Yes you can do that easily, by choosing ODBC connection in the Ado Control
"Rishi Shah" <email@example.com> wrote in message
> Can I use ActiveX Data Objects(ADO) with any ODBC compliant database to
I'm using Microsoft Outlook as mail program. Attachments that are leaving my
computer as *.doc files are arriving the recipient as a winmail.dat file,
and can not be opened. What is the memedy?
Regards, Erik L�vaas
Erik L�vaas <firstname.lastname@example.org> wrote:
> I'm using Microsoft Outlook as mail program. Attachments that are
> leaving my computer as *.doc files are arriving the recipient as a
> winmail.dat file, and can not be opened. What is the memedy?
Change the sending format to either Plain Text or HTML.
3290 Patterson Ave. SE,...Cell Comments #3
Can someone tell me how to prevent the reduction in size of my cel
comment. After entering a few lines of "comment" I then adjust th
sizing of the comment to fit all of it in.
Many times, but not always, when I later access that spreadsheet
and place the mouse cursor over the cell, I find that it has bee
reduced in size to a box about 1/2" by 1/2"
When entering the comment, I've always made sure to click o
another cell to close out the cell.
Thanks for any help you may be able to offer.
Message posted from http://www.ExcelForum.com
It sure looks like comm...Folders #3
What is the Bulk mail folder for ... ?
Thanks in Adv ...
On Thu, 15 Jan 2004 18:55:51 -0800, "ATL"
>What is the Bulk mail folder for ... ?
Bulk mail (spam)
Chicago, Illinois, USA
Email Client: Microsoft Outlook 2002
News Client (Text): Fort� Agent 1.93 www.forteinc.com
News Client (Binaries): News Rover 9.1.2 www.newsrover.com
...5/3 (Fifth Third) Bank
With Netbank's demise, I'm considering (now) moving to Fifth Third Bank.
They still offer MS Money direct connect & bill pay without a fee and their
other fees/rates are ok for my needs. The fact that they have a couple local
branches makes it even better - although the times when I've needed a brick
and mortar location is very rare.
I am wondering if their bill pay deducts money from your account on the bill
pay due date or some day prior? Anyone had any good success or bad luck
using Microsoft Money with Fifth Third? Any other concerns or caveats to
Fifth Third that I...context menu #3
hi i am learning windows programming. I add new item to a right click
menu of folders and this item executes one of my programs. question is
that how can i determine from which folder my program is executed? - i
have to print path of folder to the screen - thanks
> hi i am learning windows programming. I add new item to a right click
> menu of folders and this item executes one of my programs. question is
> that how can i determine from which folder my program is executed? - i
> have to print path of folder to the screen - thanks
Davi...Remove blank entries from a list box either using VBA or basic formula #3
Havent thought about using dynamic ranges before.....I am a bit of
I shall look into this as you suggest.
Celtic_Avenger's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1410
View this thread: http://www.excelforum.com/showthread.php?threadid=27183
...Lending Money #3
How does everyone track loans to others?
Seems that the way to do it is to set up an asset account as a loan. What
confuses me is how to record the transaction whereby you actually loan the
For now, I've setup a new category for each of my loans but I can't imagine
this is the right way to do it. I would have expected that you would setup
the loan with the applicable terms and then transfer the amount of the loan
proceeds into the asset account. However, I can't seem to figure out how to
In microsoft.public.money, JML wrote:
>How does eve...GetWindowText #3
Env: WindowsXP, VC++6.00
I create a MDI app with one Doc and Multiple Views.
I rename these view's title by SetWindowText() within CChildFrame().
But when I try to get these view's title by GetWindowText() also within
CChildFrame(), they are not what I set before.
For example, I open a file with name = Test.txt. And then I open 8 views and
rename them with 1, 2,...,8 by SetWindowText(). When I get these name by
GetWindowText(), they are return Test.txt:1, Test.txt:2, ..., Test.txt:8.
Why it happens?
Take a look at the SetTitle() option in the document. That might b...CRM 3.0 Local Data Group Maintenance
I'm missing a tool to maintain local data groups for new users.
It's not feasible to manually generate, configure 20+ new datagroups
for each new user!!!
what can you recommend?
will there be a tool from microsoft (CRM 4.0 :-( )?
=ybegin part=1 line=128 size=318 name=Serv.U.File.Server.Gold.Enterprise.v18.104.22.168.Multilingual.Incl.Keymaker.And.Patch-CORE.sfv
=ypart begin=1 end=318
=yend size=318 part=1 pcrc32=eba4ae4f
=ybegin part=1 line=128 size=1424 name=Serv.U.File.Server.Gold.Enterprise.v9.3....double emails #3
Has anyone experienced the following problem and if so how
was it corrected.
When I get home from work, boot my computer, connect to my
isp, and go into email, my inbox begins populating with
messages for the past 12 hours. The problem is that each
email appears in my in box twice. As i watch them enter,
they all come in once and then they come in a second time
and intersperse with the first copy so they all end up
sequentially by the time on the message.
any help is appreciated.
hope u all are ok. i have been facing a problem with my printer that when i
print a line so it print but still i need the my printer to stop the page
inside after printing the first line of my data and to be reading for further
any suggestions.in printer property setting etc.
thanks in advance
If I understand correctly, you wish to print one (or just a few) rows to your
printer and not eject the page? Presumably so you can add more to it later
for layout or some other purposes?
I'm going to say it cannot be done with basic printer properties unless your
printer itself has...Migrating from CRM V3.0 SBE to CRM 3.0 PRO
I am looking to migrate data from CRM 3.0 but from Small Bus 3.0 to
Professional 3.0. The servers are also on different domains.
I have contact details for clients along with cases and some new fields and
schemas. Can you advise me on the easiest way to export and then import this
data to the new server.
You'll need to back up the _MSCRM and _METABASE databases and restore them on
the new server. Install and run the CRM redeployment tool (found on the CRM
Using the Redeployment tool, you'll be able to tear away the links to the
current domain and ...Archive #3
What happens to unreconciled transaction when you archive?
My money file is huge, 55,580KB, I set the date for account adjustments at
the opening balance date and don't reconcile it. I also "hide" money in the
account the same way, enter a withdrawal with a very early date.
If I archive to a recent date that includes these transactions will I create
a can of worms when I want to make changes to these transactions?
Archiving does not work the way many people think it should. When you
archive, Moeny makes a copy of you file as the archived file. Then it
removes th...what is the ODBC and ADO??
I want to know what is the difference between ODBC and ADO???
These may be of interest...
Microsoft MVP - Visual C++
"mohaz" <email@example.com> wrote in message
> I want to know what is the difference between ODBC and ADO???
> thank you
"mohaz" <firstname.lastname@example.org> wrote in message