Share data across web applications?
I would like to share data across two separate web applications. Is this
possible, other than with Cookies? If so, how might I do it?
I would like to pass non-sensitive information from one web application to
another, on the same web server and running within the same website. I'm
using .NET Framework v2.0 on a Windows 2003 server (IIS 6.0).
Jason Barnett wrote:
> I would like to share data across two separate web applications. Is this
> possible, other than with Cookies? If so, how might I do it?
> I would like to pass non-sensitive information from one...Pivot Table
I've this problem, when I drag the fields into the "Data"
area, it will show as "Count of Q1 Results". But what I
actually want is "Sum of Q1 Results". I would have to
manually go to field setting and reconfigure from count
It happens for all the fields I drag into the "Data"
area. Is there any way around this? Thanks.
If there are blank cells, or cells with text, in the column, Excel will
default to the Count function when the field is added to the data area.
If the column contains only numbers, it should default to Sum.
Derrick wr...Keeping the format but update the data
I have a report I run everyday. I want to update the data, but keep the
column sizes and formatting. Any suggestions? Anybody suggest a good ebook to
become more formuliar with excel?
JoeM, this could be as simple as recording a macro during the formatting of
the sheet after importing the data once. Then each day, after importing the
new data, you simply run that macro.
As for online eBook's for Excel, I'm not actually aware of any although I
suspect a Google search would turn up several. It's hard to beat the "For
Dummies..." series of hardcopy...How to paste a cells row from Excel to a PowerPoint 2003 Table row?
How to paste a row of cells from Excel to a PowerPoint 2003 Table row?
PowerPoint 2003 pastes all the row cells values in every cell in the row in
the PowerPoint table if I select the row in the PP table before the pasting.
PP pastes the row as an overlapping column if I place cursor in the first
cell of the target row before pasting.
...Create Pivot Table Reports
I just finished installing Analysis Cube on the server, everything seemed
working fine until when I try to create the Pivot Table Report
(Tools->Analysis Cubes->Create Pivot Table Reprots). After I called up the
pre-defined 'Definition ID' and click on the Excel icon, a message popped up
saying " The WHTemplate.XLT file was not found."
Anybody have any idea what that is, and how to resolve it??
1.) There are two pieces of software. Did you install both the server
piece, and the client piece?
2.) Is Excel installed on the machine, on which you'r...How do I get the data/xml/export option
My export option is disabled under data/xml tab. What is the exact feature I
need to install to get this export xml option. I didn't install all the
option during excel installation. Which specific install tab are required
during excel installation?
One way would be to do a web query, first preformat the cells as text, then
do the query (data>import external data>new web query), put in the web site
address, select the part you want to import, under properties select
preserve cell formatting and do the import
(No private emails pleas...I would like to export the data from a drop-down list to a table
I have a form with several drop-down lists, I need to have the information in
these lists in another document/spread sheet. Is there an easy way to copy
the data in these lists to another location?
The long way would be to re-type all of it.
...Importing a table from Access query
What is the quickest and easiest way to do the above?
Thanks in advance.
The way I usually do this is run the select query, click on the top-right
box (which selects all records) and use Ctrl+C to copy and Ctrl+V to paste
into my workbook. An alternative is to right-click on the query in the
Database Window and left-click on Export. In the Save As dialog box, select
"Trish" <Trish@discussions.microsoft.com> wrote in message
> What is the quickest and easiest way to do the above?
>...Write conflict error with ODBC link table
I have migrate my back end access tables to SQL Server. While editing data
(ODBC link) from form, I receive Wirte conflict error 'The record has been
changed by other user... Copying the change to the clipboard...'. The error
allow me either copy the info to clipboard or drop change. In this case, how
can I save my work to the table here?
� "SF" <email@example.com> ������ ��� ������
> I have migrate my back end access tables to SQL Server. While editing data
> (ODBC link) from form, I...Import data from Excel with main tasks and subtasks
I'm new to MS Project and need help with importing data from Excel into
Project 2000. The data consists of Work Request numbers, individual phase
numbers for the Work Request, name of each phase, and (phase) start and end
I can open the Excel file in Project and map the fields, however, the data
shows up as individual tasks. I need to have the Work Request number and
project name be a main, or top-level, task, and the data related to the
phases be sub-tasks.
Here's an example of how the raw data appears in the Excel file:
Phase# P...Can I move the data files?
I just installed Money 2005. I let it take most of the defaults, It
choose to store the data files in \My Documents. I would like to move
all of them to \My Documents\My Money.
Is there a way to do that?
Simplest way is to use My Computer or Windows Explorer. Navigate to your
..mny file, click on it, click on edit > copy, navigate to where you want the
..mny file to live and click on edit > paste.
When the file is in it's new home, double click on the file name. This will
call up Money and this will then remember where it found the file.
Now go back to the original locati...Move data from column to rows HELP!!!
Hi thanks for taking the time to look at my problem, currently i have
column that has thousands of rows of information in it, it looks lik
numbers that go on into mabye the 5000-6000 range
what i need to do is have that data moved So it looks like this
A | B | C
40432 | 32432 | 532
432654 | 523 | 523
3432 | 52432 | 111
532543 | 532532 | 222
So on and so on,
so instead of 1 column with 6000 lines it ...Copying specific data from Word to Excel
What I need to do is
1) Extract the monetary amount (always after the 2nd asterisk (*) after the
2) Extract the number (always after the 2nd asterisk (*) after the letters
3) Place the numbers in the same row on an Excel spreadsheet.
4) Repeat to the end of the document.
The file I need to extract from is always text.
Is this better done from a Word macro or an Excel macro. Or can it be done
at al...Free/Busy data setting in OWA
We implemented Exchange 2003 and pushed a client setting to all users to
extend the number of months available in free/busy to 12 months with a group
policy. It works fine if everyone is using the outlook client when they are
in the office. But, if a user works at home one day or goes to a conference
and does anything that updates the free/busy data, the OWA overwrites the
users free/busy data setting it back to 2 months of free/busy available.
Where can I set the free/busy data number of months available, in OWA? Is it
a policy setting?
On Wed, 31 Jan 2007 13:54:01 -0800, SKS <sks...Import data not in correct format
Import data reads: Need to do statistical anaysis on hundreds of numbers
Cell value # of Cells don't want to enter the numbers by hand.
...Restoring Exchange Data
HI. I experienced a crash with my Windows 2000 server which is the Global
Catalog and dns server.
Anyhow in my infinite wisdom I decided to do soemthing with the exchange
server and in the meantime - it blew any active directory info which had
replicated to the exchange server. The Exchange server was a part of the
domain with AD installed, etc. The exch. server is a running windows 2003
server w/ exch. server 2003.
Fast forward...I rebuilt the Windows 2000 server and its backup. I also
rebuilt the Exchange Server...not completely knowing how to proceed....I
installed w2k3 with all ...Adding data to a list
I have a list of data that I want to add to or subtract from and I would
like to be able to click on a button which would bring up a text box where I
could insert the new data then sort the new list.
Take a look at data>form
"Mike" <firstname.lastname@example.org> wrote in message
> I have a list of data that I want to add to or subtract from and I would
> like to be able to click on a button which would bring up a text box where
> could insert the new data then sort the ne...center data labels on my column chart
How do i get my data labels to appear in the center of
each column on my chart? Thanks.
Click on one of the labels
(that will select all the labels in the series)
Choose Format>Selected Data Labels
Select the Alignment tab
From the Label Position dropdown, choose Center
Immediately after formatting the first series,
if there are other series in the chart --
Select a label in another series
Press the F4 button on the keyboard, to repeat the
formatting from the previous series
Repeat for all series
> How do i get my data labels to appear in the center of
> e...Need a formula that tags one table based 2 columns in each table
I have two tables on one worksheet, Table A and Table B. Each table
contains two column with X and Y coordinates, all values are numerical. The
coordinate system is irrelevant. I need to "tag" all XY coordinates in
Table B that have a matching XY coordinate in Table A. If Table A
coordinates are in columns A and B, and Table B coordinates are in columns C
and D, then I want to place the text "hit" in column E next to each
coordinate pair from columns C and D that match a coordinate pair in columns
A and B. The ranges for the respective tables have been named ACOORD and..."How do I get rid of old records in an Pivot Table?
The spreadsheet gets copied each month to a new file and the data cleared
out, BUT the selecetion in the Pivot Table still holds the data from Previous
Debra Dalgleish has some techniques at:
> The spreadsheet gets copied each month to a new file and the data cleared
> out, BUT the selecetion in the Pivot Table still holds the data from Previous
The web-link was very helpful, thank you. I was about to reprogram and build
my pivot tables to get rid of the obsolete item...topographical data maps in excel
I have seen this done, and would like to know how to create topgraphical maps
of data sets using excel. I want to take a sample of data ponts and plot the
points (easy), than color the plot based upon the values of the points
You seem to have been neglected by our community.
Yes, it can be done, if I understand your intention correctly. The
topography in your approach means, in a sense, the 3D chart. The first two of
the three values defininig each point specify the x- and y-coordinates (like
on a map); the third value is represented by prescribed colors or shades.
You must have you...Get External Data
I have the Office 2003 Student and Teacher edition of
Office 2003 on my home computer. I have occasion to use
the Get External Data, New Database Query function in some
of the work I bring home from work. On my version it says
it is not installed. Does the Student and Teacher edition
of Office 2003 in Excel have that option or will I need to
upgrade to a different edition to get that function?
see your other post
> I have the Office 2003 Student and Teacher edition of
> Office 2003 on my home computer. I have occasio...Get Subform Data
I'm looking for a way to get the data from a chosen record in a
continuous subform. I have a customer form and a continuous subform
with all of the charges associated with the customer. Is it possible
to have a button on the form, prompt the user to highlight a record
(the charge info.) in the continuous subform and get the information
about the charge?
If there is not a way to do this, I'm pretty sure that I can achieve
what I want to do via a list box.
Open the subform in design view, and set its Record Selectors property to
Yes. (This is a property of the Form, not o...Dynamic references in diagram source data?
Have encountered problems when copying and pasteing diagrams and their source
data areas. I wish to exclude the $ signs in the source data formulas in
order for the diagrams to retrieve data from different areas in the same
spreadsheet. This however seems impossible because excel automatically
reinsert the $ signs when I manually remove them from the source data
Any thoughts? Thanks.
...How to bind an ActiveX control to a Data Control?
I am building an ActiveX control and I need to bind my
control to a data control when using it in VB6. My
control is a multi column List. I know I should add a
property called "DataSource" that returns the recordset
of the Data control, then should move into the recordset
and add the records one by one to my list. The question
is how can I add the DataSource property and be able to
read from the data control and retrieve the data. Is
there a direct way or should I do it manually?