Pls help Asset Allocation Question
My brother is 51 years and his wife is 46 yrs old.
He is thinking of buying a home.
He is not sure of how much of his total wealth / net worth should be in
and Real estate
Someone told him that cash and bonds aside,
real estate and Stocks ( incl stock mutual funds) should be approx 50%
Since both stocks ( incl stock mutual funds) and real estate are more
volatile, he was told to split that portion of his net wealth.. 50%
Pls let me know if this is generally speaking, approximately
correct...because I know it is difficult to be absolutely correct in
these things with s...Hidden Cells #4
How do you total the number of cells in a column without includnig the hidden
cells in the same column?
If the cells are hidden as a result of filtering, you could use something
If you have manually hidden the rows, I don't know how you achieve what you
"Helpme" <Helpme@discussions.microsoft.com> wrote in message
> How do you total the number of cells in a column without includnig the
> cells in the same column?
Trevor and Helpme.
If row...Need Help of How to do a Filter
I am having problems conceptualizing how I can do a specific filtering
of a pivot table. Below is a sample pivot table that has various
colors assigned to each case number. I want to be able to filter this
pivot so that it only shows full records that contain Green.
Here is the initial pivot:
Here is my desired result (Cases that contain Green):
Could someone please advise me of how I might accomplish this. Thanks
...Error 3051 Help Please
I have developed an Access 2007 database (split into fe/be) and have access
set to shared and no locks. When I place the BE on the server and try to
connect the FE (on user PC) linked tables it is resulting in a error 3051. I
have opened 5 differnet versions of the FE on my PC (FE and BE on the pc)
without any issues.
Is this error most likely the result of permissions on the server or is
there something else I need to look at? Any hints/tips would be appreciated.
First things ti look at... Make sure you are not opening the database in
Exclusive mode and that it is ...Unable to deliver the message due to a recipient problem #4
I am running Exchsrvr 5.5 SP4 with Post Sp4 fixes in installed.
I have a user who sent an email to 4 recipients in the company and he got
this error "Unable to deliver the message due to a recipient problem". None
of the article in the knowledge base can help
Anyone ever encountered this?
Did any of them receive the message? Please post the complete NDR.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Vincez" <Vincez@discussions.microsoft.com> wrote in message
news:AFF49776-E253-4469-9561-140824BDBC05@microso...Entities with Multiple Entries - or Campaigns?
I hope someone out there will be kind enough to help me with this dilemma.
Sorry this is lengthy but hopefully the description will make it easier to
offer assistance. :-)
We do a number of "marketing events" to which we invite clients and
prospects. I've been reading a number of posts and thought I would be
brilliant and create a new entity called "Marketing Events." In my dream I
thought I would be able to create a list of events on one screen, then within
contacts I would be able to select an event that a person had attended.
Again, in my dream, I had th...Permission problem with public folder
Exchange 2000, Outlook 2000 (Office 2000) clients.
Heres what happened:
I exported the public folder to a pst file from the old Exchange 2000
server. Logged on as administrator on the new exchange server, I imported
the file to the public folder on the new server.
When I attempt to change information logged on as a user, I get the
"Your changes could not be saved because you don't have permission to modify
some or all of the items in this folder. Do you want to save a copy of this
item in the default folder fot the item?"
I went into Outlook and set the ...Help!
I can insert clip art corners into the margin areas when using Word 2007.
I cannot see how to do this using Excel 2007. The result is that the
inserted corners partially cover the cell content.
I need to produce a syllabus tommorrow using this kind of layout.
Copy the spreadsheet "table" to Word
> I can insert clip art corners into the margin areas when using Word 2007.
> I cannot see how to do this using Excel 2007. The result is that the
> inserted corners partially cover the cell content.
> I need to produce a syll...need excel worksheet help, running total based on date
I am trying to add a series of numbers in different worksheets(same
spreadsheet) based upon the date. I don't want the future numbers in the
total until the date they are associated with is passed. i.e. in A1 of each
worksheet is 200. Each worksheet is titled by date (Mar 5, Mar 19, etc) I
want the running total to reflect the amount to the current date. If it's
March 18th, the totals would be only thru the worksheet of Mar 5. Any help
My solution needs 2 cells, one of which may already be in use:
You need a cell on each of the dated sheets that...Argh. Please Help
How the #@^%$&#^% do I copy a formula from one cell to the next?
I've got ten values I want to average, and have the average show in an 11th
No problem, I can do that.
However, I've got 20 rows of these ten columns.
In the past, I've simply highlighted the cell (let's say K1) in which the
formula resides, which would read: =AVERAGE(A1:J1).
Then dragged the little black square on the bottom of the cell selection
down to fill in the cells K2 through K whatever.
It would copy the formula into each K cell, so it would say:
=AVERAGE(A2:J2) for row 2, =AVERAGE(A...xsd:any help needed
I've got the following really simple schema :
<?xml version="1.0" ?>
<xs:element name="SMSAdapter" >
<xs:element name="phone" type=...NewsMaestro Usenet Supertool v. 4.4.8 for Windows/Linux/Unix
(Hit Free button to download. For some download managers
you need to open the .html file it downloaded to do actual download.)
* Documentation update.
* Bug fix in Archive 2 HTML generator while doing ReChapter.
News Maestro is a power tool for usenet that automatically
performs any standard Usenet operation, as specified in
various RFCs, individually, or in bulk, on any number of
groups and articles, utilizing sophisticated filters to
select the articles to be processed.
As an automated tool to do anything you...File Attachment Help !
I have created table to keep a track of attached file info.
Fields are : CustID, FileName,FileLocation
In my main form I have created “Attached File” button – (to attach file –
should attach more than one) and “View Attachment” - (to view all attached
I have created two list box – one to view the list of attached file (Current
And other to view the list which is already there (previously attached)
I need to allow users to upload attachments (docs,
jpgs, tifs, etc.) to a network drive. And View the attachment when click on
“View Attached File” but...Counting formula help needed!
I'm attempting to do a spreadsheet to show our turnover data. I have sheets
titled Terms, Hires, 1st Shift, 2nd Shift and 3rd Shift. My terms and hires
sheets have a columns for name, shift and month of term/hire. My shift
sheets have the months listed down the left side. I need a formula to count
the number of 1st, 2nd and 3rd shift employees termed/hired in each month
(i.e. count the number of 1's in the shift column and 1's in the month
column, etc.). Once I have the initial formula, I can copy and make changes
where needed. I've tried everything I can th...Help!
and the on-line documentation doesn't give the right help.
Outlook on a client machine was set to send an automatic reply to any
sender saying that the manager is away on holidays. The program works
through the Exchange server on a Windows 2003 server (as required). The
version of the Exchange Server is 6.## running on server 2003 R2.
I am away from the computers as I write this but I also configured
the Exchange Server to do auto replies.
Sending a test message to the manager's e-mail user name as
configured does not produce an auto reply as it's supposed to. I...Pls Help me for install different version office on one computer
As I have old version of account software I must keep MSWord 2000 & MSExcel
2000 on my computer.
However,I only get license of standard version of office(without access
I try to install office office XP(with access xp) on my computer.
So I install office xp (choose access xp only) and I keep excel 2000 & word
2000 on the computer.
However I found that I can't use " export" function to excel2000 on access
when I do it so,the computer become hang and no response.and then I can't
open excel again.
Thx help me for doing so
I don't know if this will hel...Help with special Excel mail merge...
Hi. I'm looking for a way to replace some variable names in an HTML
file with row data from an Excel spreadsheet. I would like to create
one HTML file per row of data.
I tried doing this using the mail merge feature of Microsoft Word and
was pleased until I ran into two problems:
1. The MS Word mail merge does not substitute an image in place of an
2. The final results are printed, whereas I would like each row result
to be saved into a separate file.
Is there any app (preferably freeware) that can extract Excel row data
and replace each specified HTML variable with...Help with Page Life Expectancy
hi I am using 32bit SQL Server 2005 and SP3 applied and hosted with
Hi i have a situation where Page Life Expectancy counter shows a
consistent average of 70 seconds when running the perfmon. I read
that this should be > 300 seconds on average
Buffer Cache Hit Ratio = 99%
Memory grants pending = 0
lazy writes/sec = 0
i am trying to find out what queries are causing this but i'm not sure
how to go about doing it. does anyone have a suggestion of what to
run and look for?
Identify the queries consuming (or that will consume) the most memory
select req...help with schema for xml data from exchange server
I have xml data coming in as a stream from a web service running against
exchange server.The attributes for the elements dtstart and dtend,
are causing trouble. I tried to create schema using xmlspy and I get an
error saying name "b:dt" cannot have a namespace prefix.
I am new to xml. Can somebody please help with schema.
<dtstar...Longines Evidenza Mens Watch L2.6184.108.40.206
Longines Evidenza Mens Watch L2.6220.127.116.11
Discount Watches Site : http://www.watchespurchase.com/
Longines Evidenza Mens Watch L2.618.104.22.168 Link :
Longines Evidenza Mens Watch L2.622.214.171.124 Information :
Brand : Longines Watches ( http://www.watchespurchase.com/Longines.html
Gender : Mens
Code : L2.6126.96.36.199
Item Variations : L26714789
Movement : Automatic
Bezel : Fixed
Case Material : Stainless Steel
Case Diameter :
Dial Color : Silver Guilloche
Crystal : Sapph...Help needed with Data Validation.
I have a workbook that contains a Template sheet and several copies of it,
N01 - N0X.
I need to control what can be entered in certain cells in N01 - N0X, so need
to use Data > Validation > List. I also want users to be able to enter
their own free form text in some cells, so have to use named ranges, and
include a blank cell within the range.
I have a separate sheet 'Validation' so as to be able to only have to update
this one sheet and have the changes reflected in the drop down options in
the template and all copies.
I have played around with this and am now co...HELP #2
I recently cleaned my hard drive to the bone and reinstalled everything on
my Windows 98SE computer.
Now when I run Publisher 2000, after about 15 seconds up pops a window that
"There was a problem starting the Office Assistant. Would you like to try
I have the stand alone version of Publisher 2000.
I've tried the "Repair" option without success.
Isn't the Ofc Asst the paper clip in Word?
I have Word 97.
Anyone know the fix?
Vancouver, USA - One of the great cities in one of the 45+ countries in
OFF2000: &q...office 2004 (excel & word) afp file path issue on tiger server (10.4.9)
we have just changed over to an xserve (running 10.4.9, HFS+ with
ACLs) and are experiencing the following problem with office 2004
excel & word files only - surprisingly powerpoint files are not
all excel and word files without spaces in either file- path or -name
open just fine, however all files with spaces in file-path or -name
generate the following error message...
alt="excel error message" />
for the above we used the following example file:
-rwxr--r-- 1 daniel...stock quotes #4
How can I build a work sheet to get stock quotes and put the quote in
different cell A5, A6, A7 every day. Can this worksheet update itsel
sctroy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2592
View this thread: http://www.excelforum.com/showthread.php?threadid=48226
yes it can be done
you need the url of the webpage from which you can download into Excel
sheet(use data-get external data (or import data)> (web query)
and then you copy the relevant cell to so...Excel exact copy workbook to workbook HELP NEEDED !!
I have looked everywhere for this answer and I turn to the news groups to
find the answer.
I wish to copy a group of formulas from one excel workbook to another excel
workbook. I could drag and drop but all the fomulas now reference the
original workbook in their formulas. This is not what I wish to see. I need
it to be an exact copy. I am dealing with way too much data to retype it
all. Basically I want page six of the second workbook to look exactly like
page six from the original workbook.
Try this in Windows Explorer. Select the file. Menu pick edit/copy, then