Income and Expenses #2
Hi guys, I just added Income and Expenses to my home page and I was
wondering if there is a way to change the date range. It seems like it does
There weren't any right click options
In microsoft.public.money, Zen wrote:
>Hi guys, I just added Income and Expenses to my home page and I was
>wondering if there is a way to change the date range. It seems like it does
>There weren't any right click options
There is no such customization available. What you can do is to
customize a regular report, and add that as a Favorite for easy
access...Complicated Formula #2
Hi. I'm trying to do a very complicated formula.
I have a list of ten numbers in a row and I have one cell which is telling
me the max of those ten numbers.
This new cell I want to be able to find the number that was returned from
the above cell and then create a formula from that point. I want the formula
to keep looking back (going down the excel spreadsheet) looking for the
lowest number in a row from that number, and divide the current number by
From say a1:a10 I have :
2, 6, 4, 8, 4, 9, 3, 2, 1, 4
Cell one returns - 9
Cell two would look what came before...Cannot format Horizontal label where axis is defined as $A$2:$B$30
Cannot format Horizontal label where axis is defined as $A$2:$B$30.
I have the x-axis defined as 2 columns, but when I format the label, only
the second value follows the format.
Col A is a date and Col B is the day of the week.
Trying to get the legand to have the letters up and down but only the col B
values are following the chart formatting command.
When you have a chart with a dual-category axis the primary labels are
usually horizontal and the secondary labels direction depends on the amount
of space needed to display them. If the lables take up a lot of room they
will go ...Using Exmerge #2
I'm using Exmerge for the first time on an Exchange 2003 box. I was reading
through the KB article 174197 http://support.microsoft.com/kb/174197/
and it says "Before you run this program, make sure that the Microsoft
Outlook Client and the Microsoft Exchange Administrator program are
installed on the computer that Exmerge.exe is being run on." then in the
next paragraph it notes, "We recommend that you do not install Outlook on
the Exchange server."
So, before I go installing anything can someone please point me in the
correct direction? Can I run exmerg...Money 2005 question #2
I have used MS Money 2005 for over a year with no problems. I don't use it
for any of the more advanced features. I keep track of my credit cards, my
checking account is about all that I do, I am on disability with a fixed
But today I opened it and import a downloaded file, then I tried to write in
the check register like I have always done, Money makes a beep (which it has
never done before) and then stalls out. After a couple of minutes the blue
bar at the top says "Not Responding". It does allow me to click on the red
X, and then of course I get the window about ...excel start up #2
i have a working rota spreadsheet with dates in the columns and rota info
below, how do i get it to show todays date info at start up
With this file open and visible in the main Excel window, right-click
on the little Excel file icon to the left of the File menu (assumes
you are using xl2003) and choose View Code. Paste the following into
the code area of the VBE that will open up:
Private Sub Workbook_Open()
Dim lngRow As Long
With Sheets("Sheet1") ' amend sheet name as appropriate
lngRow = Application.Match(CLng(Date), .Range("A:A")) 'amend
column as ap...How do I print 2 page spreads from Booklet format in Publisher?
I have booklet layout with 8" x 8" pages printing on 11" x 17" paper. I
don't know how to get it where I can view individual 2 page drafts. When I
print currently, page 1 is with 44, page 2 is with 43, etc. I want to be
able to print to view in draft form page 2-3, 3-4, 4-5, etc. This is for
draft markup purposes only. I know I will print 2 sided in booklet form as
stated previously when we are ready to mass produce. Bottom line is that
we'd like to be able to print and view our book in "story board mode" (I just
coined that) so we can see whe...2 y axis, bar and line graph question
I am plotting 2 series of data against time. One series
needs to be a line and the other a bar. I got it pretty
close with the 'custom types' (built in)-- 'line - column
on 2 axis'. However, this will only let me have the
primary y-axis as the bar graph. Is it possible to
customize this further so that the primary y-axis is the
line and the secondary y-axis is the bar graph?
Thanks, please help.
...Upgrading 1.2 to 3.0
We Planning to upgrade CRM 1.2 to 3.0 for our clients.
We are trying to create a developer environment and perform the update. My
question is if we go this route how can we install 1.2 on this dev servers
(Key is unique as per domain). Can we have DEV or temp key for that
particular domain? If YES... HOW?
On the other hand if we install a fresh copy of 3.0 what is the process of
data integration from old to new DB and what kinid of information we may
loose throught this route.
As long as you have a different parent OU and a seperate CRM & SQL server,
you can install a s...Outlook unable to connect to the incoming server POP3(exchange2k3) #2
I am trying to connect outlook at my work to my exchange server at
home. OWA works great and also sending emails through outlook works,
but I can not retrieve emails from exchange using the outlook client.
Here are some of the variables:
Exchange Server at home:
Firewall Sonicwall: Pop3 on port 110 opened
Exchange was setup with default settings...in other words there have
been no special configurations
I added a new email account
Server Type: POP3 (I tried the exchange option through the control
panel, but that did not work)
My Incoming mail server: mail.myserver.com
My outgoing ...chkdsk
Server 2003 with a 4 drive RAID (500 Gb each drive).
One of the drives went south (Western Digital Caviar Black) and when the
system came back up a folder was reported as corrupted and inaccessable so I
set CHKDSK to run and restarted the machine.
8 hours later it has found one error in an index but still no signs of
finishing up anytime soon.
Is there any way to fix these errors that doesn't involve taking a server
down for an entire day?
Fiction: Check disk (CHKDSK) takes too long.
Fact: CHKDSK...why is outlook trying to open an executable file in locate link brower? #2
"Kyle Harmon" <firstname.lastname@example.org> wrote in message news:...
> In my MS Outlook 2002, every time I click on an url with-in my e-mail
> outlook trys to open an executable file in the "Locate link brower". And
> this only happens when I do not have a browers open. Is there a fix for
> Thank You,
> Kyle Harmon
Navigate to your default browser's executible (iexplore.exe for Internet
Explorer) and double click on it.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion in...The remote server did not respond to a connection attempt. #2
After the long weekend now unable to send mail to our other email domain. we
get the following message.
The remote server did not respond to a connection attempt.
Can you telnet to port 25 of the remote domain mail server?
If yes to above, then do you have Reverse DNS Pointer Record for your
domain? Have you been Blacklisted for any reason? You can check both at
John Oliver, Jr.
MCSE, MCT, CCNA, Exchange MVP
Microsoft Certified Partner
"Ron T." <RonT@discussions.microsoft.com> wrote in message
news...Restore mailbox from the 5.5 server
I wanted to know if the stand alone exchange server that I
build has to be the exact same layout as the actual
exchange server. Currently, my exchange server is running
on NT sp6a server. I wanted to build this stand alone
server on a windows 2000 if I can. I'm only trying to
recover like two mailboxes only.
Thanks in advance
you need to have the same OS and SP level that existed on the server where
the backup was taken...
"jiggyp" <email@example.com> wrote in message
> I wanted to know if the ...Exchange 2003 and 5.5 Similarities
Does anyone know of good documentation on the similarities beween Exchange
Server 2003 and Exchange Server 5.5? An example would be: Exchange 5.5 uses
one Information Store that is a single .edb file; Exchange 2003 uses multiple
storage groups home to multiple databases - each is one .edb file and one
...Change Value on Combo Box upon event
Is there a way that I can change the value on a Combo Box to the last record
in its record source?
I have a combo box that displays Fiscal Years, from 2000 to Current fiscal
year 2007. Users can select any year they wish to pull data from based on
the year selected. However, I want the combo Box to change its value to the
current Fiscal year (which is the last record presented to them when they
select the drop down) based on a specific event.
Anybody have any ideas?
Me.CourseID = Me.CourseID.ItemData(Me.CourseID.ListCount - 1)
"Angel_G" ...Updated Office 2008
Operating System: Mac OS X 10.5 (Leopard)
I am not very techno minded, so I don't know what to do. I updated Office 2008 and now it says that I have entered an invalid product key. I didn't enter any product key! I went to some of the help solutions on this site and one told me to delete the Office Folder. If I do this won't I lose all of the files I have in Word and ExceL? I am afraid to do anything, but cannot get into any files. Please help me with simple instructions if you can. Thanks.
On 8/5/09 5:08 PM, in article firstname.lastname@example.orgR9absDaxw,
"LC@...Update Table for Obsolescence
I am missing something or have a blind spot about how to do this
I have a table (TblAll Products) with all my products in it including
a yes/no field to determine if a product is obsolete or not.
I have used this years list of all existing products
(TblCurrentProducts) to create a query (qryObsoleteProducts) showing
any non matched items ie which are in TblAllProducts but not in
TblCurrentProducts and are therefore obsolete.
I tried to create an Update query from qryObsoleteProducts to set the
yes/no flag in TblAllProducts to Yes but am getting an error:
Operation must use an updatable quer...Excel Formulas Not Updating
For some reason when I create a new sheet, my formulas do not get updated when I change the value of a cell that si used to calculate the formula (I have to double click on the formula and then I get the right value). This problem does not occur when I make changes to files that I get from other people
Try Tools / Options / Calculation / Change to Automatic if on Manual
Excel takes it's calculation status from that of the first file opened after
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02...graph title #2
Is there a way to use the current filename as "Chart Title" in the "Chart
Options" of a graph ?
You can link the chart title to a cell. See here for instructions.
And the cell to which you link can contain this formula, which will
extract the filename from the returned string. I have split the formula
over 3 lines in case wrapping within the email screws with the formula.
CELL("filename",A1))-FIND("[&q...linking worksheets #2
How can i link to an entire worksheet in another workbook, so tha
changes may be made to the worksheet ragerdless of which workboo
containing the sheet is opened?
bails's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3615
View this thread: http://www.excelforum.com/showthread.php?threadid=56114
If I understand what you're asking for, it can't be done.
You want Workbook1 to have a sheet in it named Sheet1
Then in Workbook2 you also want a sheet named Sheet1
(and actu...Text Formatting 2
I have a spreadsheet with 2 versions of text in 1 columm
1. 1 column = firstname and initial. For example Dave C.
2. 1 column = firstname. For example Dave
DaveO kindly provided this suggestion:
where D7 contains the name in question. This formula returns
everything before the first blank space in the entry
This works perfectly for situation number 1, but in situation 2 I get a
How can I mask the cell to be just the first name in both scenarios?
=IF(ISERROR(FIND(" ",D7,1)),D7,MID(D7,1,FIND(&...2 envelope icons?
Has anyone ever heard of 2 envelope icons displaying at
the bottom of your screen, rather than just one.
Sometimes I have 2 little envelopes down there and only
one email - but even still, I have never heard of or seen
2 before. ANy idea what that means?
In order to get my line chart to break off I used #N/A.
However my final value is an average. Since I am using the
#N/A, I get that for my result in my Average calculation.
Is there a work around for this?
#N/A Average - I want to see 4
Try this =AVERAGE(IF(ISNUMBER(A1:A5),A1:A5,""))
You must enter it as an array formula with Shift+CTRL+Enter
"Jason" <email@example.com> wrote in message
> In order to get my line chart to break off I used #N/A.
&...5 Dollars Real Money
DONT MISS THIS BE QUICK!!!!!
Get seven separate pieces of paper and write the following on
each piece of paper "PLEASE PUT ME ON YOUR MAILING LIST."
Now get 7 U.S. $1.00 bills or UK �1.00 or 1 � (euro)
and place ONE inside of EACH of the seven
pieces of paper so the bill or coin will not be seen through the envelope
prevent thievery). you better tape the coin on the paper. Next, place one
paper in each of the seven envelopes
and seal them. You now should have seven sealed envelopes, each with a
piece of paper stating the above phrase, your name and address, and ...