Copying XML data to Word
I have got an Excel XML spreadsheet which grabs data from Microsoft
CRM. I have set it up to have 5 different sheets.
I want to copy information from each of these sheets into Word, but for
some reason, only data from the first sheet is copied. When I try to
copy cells from other sheets, I get blank cells in Word.
Can anyone tell me why?
And even better, is there an automatic way to copy this stuff into a
Word template so I don't have to manually select the cells?
...Can I use named range in data range box when creating pie chart?
I have 75 pie charts to create today. Is there a way to use named ranges in
the data range box to speed this up?
Yes. Just type in the name.
Remove 'Junk' from return address.
"BJackson" <BJackson@discussions.microsoft.com> wrote in message
>I have 75 pie charts to create today. Is there a way to use named ranges
> the data range box to speed this up?
Thank you! I was making it too difficult, thinking I needed to include the
Sheet name along with the name range. ...Payroll Data Encryption
Is there a product out there that allows encryption of payroll tables
so that IT administrators with sa password access cannot see the
...How do I get a graphy with 2 data sets to have 2 Y axis one for each data set?
How do I get a graphy with 2 data sets to have 2 Y axis one for each
On Jul 20, 5:26 am, libertyforall <r...@royhuff.com> wrote:
> How do I get a graphy with 2 data sets to have 2 Y axis one for each
> data set?
have a look at Jon Peltier's beatiful site, especially:
Have fun, cheers
...View other BU data
Let say there are 4 BU define in my systems and name it as BU1 up to BU4
accordingly. And each BU has manager and sales person that is different from
other BU. Is it possible that BU1 manager can see all lead, opportunity for
BU2? But BU2 manager cannot see the BU1 lead and opportunity??
yes it is possible by using different security roles for the two different
sales managers (they have different access rights and should therefore have
It is also possible using BU hierarchy and placing the managers in a
aggregate BU or in the bottom one dependin...Macro to sort variable data range fails
Can you please help me identify why this macro is failing with the
Runtime error 1004: Sort method of Range class failed
Row 7 is the header row
Data range has a variable number of rows (so using end(xldown) to
select the range)
Using column BA to select a contiguous range of cells as all cells are
populated in the column
Then using that selection to select entire rows in my list
Sorting as per criteria using row 7 as header row
...MAXIMUM Data Input in Excel
Does anyone know the approximate (or exact) limit of Excel for storing data?
I have heard the number 65,000 lines of data, but want to verify this number.
I guess you have never looked at a worksheet and done end +down arror to see
that, in the later versions, there are 65336 rows and 256 columns.
"Tom" <Tom@discussions.microsoft.com> wrote in message
> Does anyone know the approximate (or exact) limit of Excel for storing
> I have heard the...Data Analysis help?
I've got some time series data which is approximately constant for
awhile, and then drops off as -(a exp(b x)). Is there a way I can have
Excel help me to determine what the "best" place to consider the
constant section as stopping and the exponential section as beginning?
It should be straighforward to determine the exponenetial's parameters
Thanks for any ideas,
Rather than considering the range as the spline of two separate processes,
can you construct a single mathematical model that covers both parts of your
If it is possible, then...More on "Data Range"
This is wonderful for using "OFFSET" for a Dynamic Range Name
for a Chart "Data Range"...http://processtrends.com/pg_dynamic_charts.htm
Thank you again Kelly O'Day.
It includes, for the X-Axis Dynamic Range Name...
"Refers to:" ---> =OFFSET(dyn_ranges!$A$2,0,0,COUNTA(dyn_ranges!$A$A)-1)
Currently, I'm using Column A to receive several Ranges for Charts from
The...COUNTA(dyn_ranges!$A$A) will Count Entries in Column A from Cell
$A$2 down. Other than separating the Ranges...IE..
For Chart 1...Columns A:B ---> COUNTA(dyn_ranges!$...Excel chart data labels showing % change instead of value?
I'm needing to have my excel chart show me the percent change in my 2 series.
I would like this in a data label over series 2 on the chart, but all I can
figure out to do is have the value labeled. Does any one have any
suggestions? I'm believe I'm using Excel 2002.
You can use Rob Bovey's XY Chart Labeler.
"MFritz" <MFritz@discussions.microsoft.com> wrote in message
> I'm needing to have my excel chart show me the percent change in my 2...Migration Exchange 2003 to Lotus
I'm traing to migrate my lotus to Exchange 2003, I has
ready my connector, i stoped, and start de Wizard to meke
the migration, but the migration fail, and post a event
12010, i found in support and new group that exist a
q824282 that fix this error but this Q it's for Exchange
2000 and I have Exchange 2003, what can I do???
Install de Q824282 in my Exchange 2003????
The text of the error is
Failed to initialize the Notes Migration session.
Make sure 'ntsmig.ini' is in the 'exchsrvr\bin' directory.
but the file exist in the directory.
...GP 9.2 on btrieve migration to gp 7.5/8
First I am having trouble putting GP 8.0 on a 98 machine is this not
supported? Now to the good stuff, our company has been on GPA for 10 years
and has now purchased GP 7.5/8. I am in need of some direction and help on
the migration of this old system to the new. I am new to btrieve but not to
sql which is what we have for the db sql 2k. What is the best approach to
migrating this data to the new system?
This is a complex migration/upgrade. There are a few upgrade / migration
steps you need to do to get MGP to v 7.5 / 8.0.
You would need to purchase MGP migration tools from...combining data from separate sheets into one
I would be grateful if someone could start me off on a macro to
combine data (size variable) from a number of sheets (number unknown)
from a single file. The data will always start in the same cell, A6.
Can you be a bit more specific on what exactly do you want
to do? Do you want to, say, add the values of cell A6 in
all sheets in A6 in a totals sheet, or something like
this? Do you want to do this for a range of cells? Does
your totals sheet have a specific name (so it can be
excluded from the summation?
>-----Original Message...Automatic Pareto data with Formula
I want to create a data table for use to create an Automatically updated
Pareto Chart, for this I need that the values automatically be sorted in
descending order, so I have the following example scenario:
Column A has Labels and Column B has Values
C - 3
D - 2
If I use the following formula:
I get B, but there are two 2 and if I use the 3rd largest:
I also Get B instead of the required D.
How can I get it so the end results looks like this:
...How do you entr data in a form (scanned) document?
I have a printed form I need to fill out by entering data. How do I ues Word
to do so? I can scan the form to creat a (picture) document. How do I enter
data in this document (by overlay) to enable printing it with entered data?
You could use text boxes for your info.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Filling in preprinted forms" <Filling in preprinted
firstname.lastname@example.org> wrote in message
>I have a printe...Email Tracking in CRM 11-02-07
When we send an email from Outlook and "track it", it places the email in
History for the account associated with it. How do we make CRM use the
sender of the email who is the OwnerID (created by) field show up instead of
Is SYSTEM a user that CRM uses internally when emails come in?
...Data Labels Widths
Can the width of a data label for a MS Chart (in my case a
pie graph) be widened. There appears to be no property
for this. I have downloaded some utilities but these are
for simply creating label with bespoke text and do not
allow me to adjust the width... help!!!
The maximum width of a data label seems to be proportional to the width
of the chart object. You can make the chart wider to fit a longer label.
Most of a chart's text elements do not allow you to control their
dimensions. You can add textboxes, however, that allow you to adjust
their size. The...Finding Last Data in a Column
Does anyone kow how to find the last entry in a single column the
paste it into another cell?
For instance - Looking at column J - Find the last entry or last cel
with data in it then copy this data into another cell eg J5.
Any help much appreciated
Mike:) :) :
Message posted from http://www.ExcelForum.com
"MacroMike >" <<MacroMike.email@example.com> a �crit dans le
message de news:MacroMike.1...Getting straight lines in a best fit trendline of semi log data?
Thanks in advance for any light you can shed. I have been asked to
create a graph that looks like this:
It is a semi-log representation of a time series. I have created a
As you can see, the trendlines are curved. I have serched the
archives but I'm missing a basic understanding of what to do. For
example, the TREND function just gave me a specific value. If anyone
can tell me how to make my clunky graph resemble the spiify published
one, you will save both my...Combined bar and line chart (two Y axis) how to make excel know which data goes where
after the super fast problem fixing last time i had a problem, i'd like
to ask the excel collective for some more help... :)
now trying to plot a combined bar chart and line graph. I basically
want all the sets of data except one to appear as columns plotted
against the axis on the left and the last set of data (which is a
cumulative value of the data appearing for the columns) plotted against
the right hand axis as a line.
I can plot the graph fine, but out of the 7 sets of data which i want
to appear as 6 sets of columns and one line, i get four sets of columns
and three ...Migrating
I got a new comuter and trying to find a simple way to migrate everything-
all of the documentation talks about moving .pst files which seems easy
enough but it but what about-
Is there asomething out there that will just move transfer the whole lot?
To add to the confusion I have 3 separet profiles.
"Jay" <Jay@discussions.microsoft.com> wrote in message
> I got a new comuter and trying to find a simple way to migrate everything-
> all of the ...RANKING alters when data is filtered
Have spread sheet with list of percentages - adjacant column displays numeric
ranking of these percentages - when i filter the percentage column (eg sort
ascending) the formulas (cells that are being ranked) and hence the numeric
ranking are changing - each row is ranking different cells within the same
A B C
2 ABL 4% 4 (rank by cells C2-C6)
3 ING 5% 5 (rank by cells C2-C6)
4 CBA 1% 1 (rank by cells C2-C6)
5 AMP 3% 3 (rank by cells C2-C6)
6 ANZ 2% ...How to link data and it's formats bewteen worksheets
I am using Office v.X for mac. I have a workbook that that has master
worksheet with A1:AK4 column headings and A5:AK265 has data with
different formats (date,text,number etc.) I want to create new
worksheet as a diiferent catagories with linking data from the master
worksheet. So when i edit the master worksheet it edits the other
worksheet simultaneous. For example rows 5,15,70,100 belongs to
catagory1 being worksheet2 and rows 10,50,200 being another catagory as
another worksheet and so on. Different rows will make up 6 catagories
in turns 6 worksheets.
I have tried using paste link but i l...Dates 06-18-07
My problem: I am trying to have one date minus another date. I want to
display the difference in days. Help!
DateDiff("d", [StartDate], [EndDate])
> My problem: I am trying to have one date minus another date. I want to
> display the difference in days. Help!
...i need to create a chart from data from one workbook in another wo
new to excell so please be kind. i need to create a series of charts from
different sets of data in one workbook, and have the charts show in another
seperate workbook, and update automaticly when the data changes in the first
i know how to create charts, its just that i can't get it linking from one
workbook to another
An easy approach would be:
Make the charts in the workbook containing the data. Cut and paste those
charts into a new workbook. The charts are still linked to the original
workbook. If you make changes in the data, the charts...