Copying XML data to WordI 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?
...
Disappearing email #2Dear Jeff,
I'm apologize if I'm missing something obvious here, but I
can't see the item(s) on the View menu which determines
whether or not all messages are displayed...
Steve
>-----Original Message-----
>Go to the View menu and make sure that you're view is set
to view all
>messages.
...
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.
--
George Nicholson
Remove 'Junk' from return address.
"BJackson" <BJackson@discussions.microsoft.com> wrote in message
news:0DE9A0AD-C3BA-4242-B3BA-3CC3F0D87894@microsoft.com...
>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?
Thank you! I was making it too difficult, thinking I needed to include the
Sheet name along with the name range. ...
Messages Disappear?Hi,
We're using Outlook 2003, cache mode, to connect to our Exchange and Windows
server 2003. Everything patched. One of the users complains that some
messages (last week)disappeared suddenly. There's no filters, rules setup.
She said those messages were there two days ago. the current View is all
messages(read and unread). I also tried switching to non-cache mode and
still can't find those missing emails dated last week. I even logged on to
OWA and still can't find those missing messages. I checked the Deleted
Items, Junk, all other folders and those messages we...
for rent office tower in bosphorus,besiktas,istanbul TurkeyBusiness Towers located in Besiktas ,istanbul one of the commercial
and residential town in Europe side of the city .
Fan-coil system
Settling area net 653sqm.total 21 floors,13.713 sq.mt 2 regular
floors,1 tecnical floors ,4 garage floors(total 150 car park )
per flat 653sq.mt
Price: sqm/20USD + TAX per mounth
A striking modern building, with panoramic views over the Bosphorus,
located in the heart of banking and business district. Plaza
offers a prime business address in a very strategic location. Close
to
Turkey's Stock Exchange and within 15 minutes to t...
Payroll Data EncryptionIs there a product out there that allows encryption of payroll tables
so that IT administrators with sa password access cannot see the
payroll information?
...
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
data set?
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?
Hi libertyforall,
have a look at Jon Peltier's beatiful site, especially:
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html
Have fun, cheers
Michael
...
View other BU dataHi,
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??
Thx,
Carrie
Hi,
yes it is possible by using different security roles for the two different
sales managers (they have different access rights and should therefore have
different roles).
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 failsHi,
Can you please help me identify why this macro is failing with the
following error?
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
Rows("7:7").Select
Range("BA7").Activate
Range(ActiveCell, ActiveCell.End(xlDown)).Select
...
MAXIMUM Data Input in ExcelDoes 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.
Thanks.
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.
--
Don Guillett
SalesAid Software
donaldb@281.com
"Tom" <Tom@discussions.microsoft.com> wrote in message
news:C780540D-BD2A-45BE-B159-C746BE6A9022@microsoft.com...
> Does anyone know the approximate (or exact) limit of Excel for storing
data?
>
> I have heard the...
Data Analysis help?Hi all,
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
after that.
Thanks for any ideas,
cdj
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
data?
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
Access Automation.
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.
http://www.appspro.com/Utilities/ChartLabeler.htm
"MFritz" <MFritz@discussions.microsoft.com> wrote in message
news:29317BE2-4574-4623-8D5E-A3BA97B3FAE6@microsoft.com...
> I'm needing to have my excel chart show me the percent change in my 2...
how do i put a password on an office document?i used to go to save as & then in options/security I could put a password -
its now not there (publisher 2003). please help
You have Publisher confused with Word...
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"justicerulesok" <justicerulesok@discussions.microsoft.com> wrote in message
news:2B9DEF7C-C057-4E80-B7F9-B9BB39A8241B@microsoft.com...
>i used to go to save as & then in options/security I could put a password -
> its now not there (publisher 2003). please help
...
Multiple Versions of Office AppsVersion: v.X
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I have not upgraded to Office 2008 because the budgeting programs I use in Excel require macros. I do, however, want to upgrade Entourage for better Exchange compatibility.
If I install Office 2008, can I still keep my Office X version of Excel on the same system (PowerBook G4)? Will there be conflicts?
Thanks,
-Jd
On 3/25/08 9:04 AM, in article ee95f9d.-1@webcrossing.caR9absDaxw,
"jdbrewer@officeformac.com" <jdbrewer@officeformac.com> wrote:
> Version: v.X
> Operating System: Mac OS X 10.4 (Tig...
revert from outlook 2007 to office XPnew pc so loaded a trial version of outlook 2007, but don't want to
upgrade and want to stick with office outlook XP.
i think i made an error by not loading outlook XP first on this
computer, and wonder how to revert without losing content/data that's
now part of outlook 2007.
do i delete 2007 then load XP?
thanks all.
"loki" <craigmclaughlan_remove@terra.es> wrote in message
news:OwdF$TbNIHA.6108@TK2MSFTNGP03.phx.gbl...
> new pc so loaded a trial version of outlook 2007, but don't want to
> upgrade and want to stick with office outlook XP.
>
>...
combining data from separate sheets into oneGreetings
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.
Many thanks
Yours
Andrew j
Fife
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?
Nikos Y.
>-----Original Message...
Automatic Pareto data with FormulaI 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
A -1
B -2
C - 3
D - 2
E -1
If I use the following formula:
=INDEX($A$1:$A$5,MATCH(LARGE($B$1:$B$5,2),$B$1:$B$5,0))
I get B, but there are two 2 and if I use the 3rd largest:
=INDEX($A$1:$A$5,MATCH(LARGE($B$1:$B$5,3),$B$1:$B$5,0))
I also Get B instead of the required D.
How can I get it so the end results looks like this:
C
...
Office VX and Mac OS9.2It's a silly question, but i think OfficeX isn't compatible with OS9.2: can
someone confirm this think?
Thanks a lot
Denis Chenu
Service informatique / Informatic service's
SAD-Marketing
D.Chenu@sad-Marketing.com
03.20.81.58.20
-------------------------------
You're correct. Mac OS X is an entirely different OS and takes entirely
different software from OS 9.x and below (OS 9.x is � equivalent to the
Classic system within OS X). Office 2001 is the last OS 9.x compatible
version--Office X and the forthcoming Office 2004 are written for OS X.
Dayo
"D.Chenu" wrot...
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.
--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Filling in preprinted forms" <Filling in preprinted
forms@discussions.microsoft.com> wrote in message
news:659EAF90-C3E9-4C24-BDCC-11DAB1A95A87@microsoft.com...
>I have a printe...
Data Labels WidthsCan 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!!!
Many thanks...
Mike -
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 ColumnHi,
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
Hi Mike
WorkSheets("Sheet1").Range("J65536").End(xlUp).Copy
WorkSheets("Sheet1").Range("J5")
HTH
Cordially
Pascal
"MacroMike >" <<MacroMike.19mqp2@excelforum-nospam.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:
http://www.jci.org/cgi/content/full/98/2/490/F4
It is a semi-log representation of a time series. I have created a
spreadsheet here:
http://ccbc.unc.edu/documents/logarithmic_test_graph.xls
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
Hello all,
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 ...
OWA Hotfix for XP Office 2003I need the OWA hotix for Exchange 5.5. OWA keeps hanging
after 2003 Outlook clients connect.
"Pedro" <anonymous@discussions.microsoft.com> wrote in message
news:bbf001c48939$9b02ce10$a601280a@phx.gbl...
>I need the OWA hotix for Exchange 5.5. OWA keeps hanging
> after 2003 Outlook clients connect.
You can get it here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=B106C749-71F8-44CC-86CF-AB5CDA169127
Lee.
--
_______________________________________
Outlook Web Access For PDA , OWA For WAP:
www.leederbyshire.com
email a@t leederbyshire d.0.t c.0.m
_____...