Using Relative path for XML data file?
Is there a way to specify a relative path to an XML data file imported into
Excel 2003? I am writing a web app that generates report data as XML for the
user to download to their local machine. This data is to be consumed by an
Excel reporting spreadsheet, which contains display-formatted tables and
charts that are mapped to various data fields in an XML Map, which is in turn
linked to the xml data file they will download.
The idea is the user only needs to download the data for updates, not the
whole spreadsheet. However, since I cannot predict the path where the user
will store their...Changing Cells and entering data in them
Thanks for the help again.
Big thanks to Steve you've got me this far.
I went out and bought a book, but it's like reading a
I was informed today that I can't have message boxes come
I need to have the code point at the cells and if they are
blank turn which ever one is blank red or if both are then
both turn red then pause for each cell to be filled in.
Cell F14 "Last Name" then automatically go to Cell
F16 "First Name" on tab or enter.
Basically if Cell F22 or F23 has an X in it, Cells F14 an
F16 turn red and cell F14 has the focus...Pivot Table Question #5
How do I make the row headers show up in front of each row
on pivot table instead of just once on the first row of a
Copy the pivot table
Do a Paste Special > Values into another sheet
Ensure that the top left cell is A1
Run the Sub FillBlanks() below
(from MVP Debra D)
'by Debra Dalgleish 7-Dec-2001
'fill blanks cells with data from above
.FormulaR1C1 = "=R[-1]C"
Range("A1").PasteS...Is anyone an expert with outlook that I can call on the phone?
How do I share calenders between outlook and my MSN Premier account?
Assuming you are using the outlook connector, you need to set the msn
account to be the default message store then outlook will use the msn
calendar as the default.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
You can access this...data sort
ok now should be simple >>
I need to sort by month on data that is held in format >> day/month
custom/ends with/ 11... does not work
custom/ends with/ ??11.. or *11 does not work either
contains 11 does not work (& would also be wrong if data set contained 1011)
but still I am stumped so any help would be great
I would be inclined to add a new, temporary field of formulas that pull off
the right 2 digits, and sort by that: =RIGHT(A1,2)
...Pulling data from separate tabs
When charting in Excel 2002 is there a way to use sets of
data from two different tabs within the same worksheet?
For example, a spreadsheet contains separate tabs for
prior year and current year data. Is there a way to
reference the data or label series to pick up data from
I tried pointing and clicking, and then typing the
following as a reference for the axis labels:
='Prior Year'!$B$110:$M$110,'Current Year'!'$B$110:$M$110
but receive an error that I'm referring to an external
I've used the comma (') in the past to reference breaks ...unable to paste Excel 2003 chart into Outlook 2003
(This was posted on "excel.charting" group.)
I have a user who's unable to paste an Excel 2003 chart into Outlook 2003
email message. In Outlook options, the checkbox is selected for "Use
Microsoft Office Word 2003 to edit e-mail messages".
When I tested this on my own computer running the same version of Office, if
the box is check, I have no problem pasting; if this box is cleared, I
cannot paste. But on his computer, it doesn't work regardless.
Thanks and regards,
...Can't do adjustment in analytical accounting
I am trying to change an analytical assignmnet through the Edit
Analysis. When I try and change it, I receive an error stating "The
Code of this Transaction Dimension cannot be adjusted". Has anyone
seen this before? I have done similar changes many times, but I don't
know why I can't now. Any insight would be helpful.
What version of Gp are you running? I haveseen this happen in 8 but one of
the service packs fixed it. (I think it was SP 4 or 5)
> I am trying to change an analytical assignmnet through the Edit
>...Can I share entities in migration process?
The entities in CRM have only one owning user. If I want=20
who a user see a entity of another user, the entity must=20
be shared with this user.=20
Well, I want migrate entities who must be shared with some=20
users. Exists a way to do it?
Thank you for pay attention and sorry my bad english.
Vin=EDcius Pitta Lima de Ara=FAjo
...Formula for cross tab data filling
How to using formula for data filling as below (Y/N) ?
Product A Product B Product C
System A Y N Y
System B Y Y N
System A Product A
System A Product C
System B Product A
System B Product B
...Help with importing data
Can I have users fill in a form in Access and have that data be transferred
and updated to a spreadsheet. Need for fill out several fields and then
export to a specific spreadsheet and place that data into the cells that will
update that cell (add to the total in that cell) of a spreadsheet.
...form fields not saving to table
I have created a database with a form and three of the fields are not saving
the information to the table. I have checked the row and control sources and
now at a loss and thoughts?
As you scroll through existing records is the data of the table displayed?
Post the SQL of the query or form source.
Build a little, test a little.
> I have created a database with a form and three of the fields are not saving
> the information to the table. I have checked the row and control sources and
> now at a loss and thoughts?
...how do I add error bars to a 3D chart in excel?
The help states you can only add error bars to data series in 2D area. Is
there a way to add them to a 3D chart?
I would not have thought so. Obviously as it is not a built-in option
the only way would be a work around perhaps using dummy series.
Unfortunately you can create 3d combination charts.
Stick with the 2d view.
> The help states you can only add error bars to data series in 2D area. Is
> there a way to add them to a 3D chart?
Andy Pope, Microsoft MVP - Excel
I checked, and error bars are not offered for 3D ch...Table of Contents for each section
I have tried several times to create a TOC for each section of my document.
They way it is now I can simply go to the Insert a TOC and it will insert e
perfect TOC. All my text has been changed to the appropriate Level and I have
no problem there. But I need to seperate the chapters to the start of their
respective sections (I have next page breaks inserted at the start of every
chapter). I have tried the bookmark method, no luck. I have tried other
methods but I think my problem is that I have selected the appropriate fields
and changed their levels appropriately. I have not mes...Status in table PurchaseOrderEntryDetail
We're trying to populate serial # into the PurchaseOrderEntryDetail table
and run across the column 'Status'. What are the possible values for Status
column in this table? Most of the time we see status of '2'. What does that
mean? Please help.
Many Thanks & Best Regards,
...Let me use the Line Color icon on charts
It would speed up a lot of my work if I could use the Line Color icon on
Excel charts, the same way I am able to use the Fill Color and Font Color
However, when I highlight any chart object, like the Plot Area, Chart Area,
or a Series, the Line Color icon is disabled.
Stuart Bratesman, Jr., MPP
Muskie School of Public Service
Univ. of Southern Maine
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If ...predict future data
Is there a way to create an XY line graph wih plotted
data, yet leave room to predict future data on the axes?
I can get the graph, but the x and y axes stop at the last
data points, and I want those axes continued so that the
existing data can be examined and future data predicted
and plotted on the same graph, but I am not sure how to
accomplish this. Any suggestions would be appreciated.
1) Click on data series in chart, use Add trendline; in Option tab specify
some units forward
2) Read Help about TREND and FORECAST, and SLOPE and INTERCEPT
3) Get crystal bal...Reference / Copy Dynamic Data
Have a worksheet listing products and prices for numerous suppliers.
This worksheet will change often.
What I would like is to reference this information on other worksheets.
I would also split the info onto a worksheet for each supplier.
Therefore i will have a worksheet for ABC and for XYZ, and the info in
these worksheets will change as the main "index" worksheet changes.
Worksheet ABC contains:
...How do I find the Data Analysis Plus toolpak for excel
does anyone know where I could find the data analysis plus toolpak.
> does anyone know where I could find the data analysis plus toolpak. <
Start by looking on the CD that was in the back of the textbook.
...Unjoin tables in query
I have 2 tables (table1 & table2) in query that don't have a relational field
each other. Table1 has Date, decription & amount. Table2 has RecordNo &
filenm. I'd like to pull all fields in Table1 and only the last record of
field Filenm in table2.
How can I make a query to produce report like that. If anybody can tell me,
I'm very appreciated. Thanks
Message posted via AccessMonster.com
It works. Thank you very much....
Jerry Whittle wrote:
>First create a query called qryLastFil...' in numbers and Pivot tables
I have a spreadsheet with multiple rows of the same ID
number. The ID number (when you click on the cell) has
a ' before the number.
I have created a pivot table to condese this data into
something more meaningful. (which works) However I do not
see any ' in front of the ID number.
I now need to use vlookup to lookup a value with the same
ID as I have on another sheet. But when I use the vlookup
formula, I get #N/A. However if I manually add ' in front
of the ID in the main sheet it looks it up. There are
thousands of rows, but I do not fancy putting an ' in
f...can't open new worksheets in a separate window
I've been trying to open multiple wookbooks in Excel, but they won't open in
a new window. Instead they continue to open in the same window - one on top
of the other. I've tried playing around with the maximize and restore, but
to no avail. I tried right clicking on the Excel button in the taskbar to
cascade the windows, but the pop-up menu is inactive. any advice would be
Running Excel 2003, Windows XP.
This might be it:
Tools - Options - View tab - Show: Windows in taskbar.
"3R's" <3R's@di...Can validation lists be enlarged
When a validtion list is created can this be enlarged in a spreadsheet which
has been reduced to view.
for a workaround see:
"AC" <AC@discussions.microsoft.com> schrieb im Newsbeitrag
> When a validtion list is created can this be enlarged in a
> has been reduced to view.
...GPS 8 service pack 2 and add new company
After installing service pack 2 for GP 8, I am not able to add or log on to
the new company. Error during upgrade is “Entries haven't made to all
required fields. Would you like to show the required fields on all windows in
When I try to log on to GP getting another error “file for this company have
not been updated”
...How can I change text to proper text in multiple cells.
I need to change names that are all in caps to proper case in 100 cells.
If I click each one individually, it works, but I need to be able to perfomr
this funcion automatically on all the cells. One other post said to be sure
calc is set to automatic and mine is. Any instruction is most appreciated.
Insert a helper column to the right of the column with the names.
Then use a formula like:
and drag down that column
Then select that column
select the original range
And then delete the helper column.