How do I create a list when it is not in the Data tool bar?
I need to create a list, but when I drop down the Data from the tool bar,
"list" is not an option under it. What should I do?
Until the most recent XL version, a list was just an informal way of
organizing data in a worksheet. It still is, really. It's just a matter of
putting different records in different rows, different variables (or
"fields") in different columns, and the name of each variable in the list's
first row. The column variables should be adjacent to one another, as should
the records in the rows. Some Excel features work much more easily...Excel>Data>Import External Data>New Web query #2
I am trying to use Excel 2003 to import data from
I use new web query on the above url.
I select the data in the block under 'My Favourite Quotes'
The wizard behaves as expected but only returns 1 line not the 3 that have
Can someone please give me some pointers on how I can get the 3 lines.
Try yahoo instead or go here and get my FREE excel file for quotes or
history. Look for donaldb36 as author.
donaldb@...Repost: Test Linked form for data
This was originally posted on September 14, 2007. "Test Linked form for
How can I test to see if a linked form, that might not be visible, has data?
My main form has a yes/no box that enables a button when it is set to yes.
The button opens a linked form. When the user moves to the next record, I
would like the main forms BeforeUpdate event to make sure that the yes/no
box is not set at No while there is data in the linked form for that record.
I have tried something like:
If Me.Form.frmVehicles.RecordsetClone.RecordCount > 0 And Me.CompanyVehicle
= False ...Troubleshoot Publisher Data Source
Everytime I try to Mail Merge my data source (Excel file) I get a "dialog or data base engine failure" How do I correct this so I can use the data in my publication?
Refresh your MDAC components
Click on MDAC 2.8 on the right pane
Mary Sauer MS MVP
"NancyF" <NancyF@discussions.microsoft.com> wrote in message
> Everytime I try to Mail Merge my data source (Excel file) I get a "dia...Printing a Report with Parameters
When printing a report with Parameters. The report will come up on the
screen after you enter the parameter. When you then print the report it asks
for the parameter again. After we click finish, the following error appears
on the screen
'Information is needed before this report can be processed (On Cache
The report will not print.
what server os is your crm web running and also what is your domain
also its possible you have embedded the servername in the report.
open the report in crystal designer and go to database-verify dat...X,Z,ZZ REPORT
ANy way to get a shorter form of x,z,zz report for RMS?
Does Anyone know how to customise the z report?
I don't see any attachement as mentioned, where can I get one ?
may be you can email me the report to firstname.lastname@example.org
> kase wrote:
> > Hi,
> > ANy way to get a shorter form of x,z,zz report for RMS?
> > Does Anyone know how to customise the z report?
> > Regards
> > kase
> I attached my SHORT report. I only having IN/OUT and over/short. I
> deleted all the ...using Access Data
I have a slight problem with Charts in Excel & Access. I'm creating charts
that can use up to 50,000 data points (if not more) and in Excel there is
significant lag time (up to 2 minutes just to rescale an axis or change the
title). I decided to try and use Access to organize the data, but creating a
chart in Access is a pain because there is a 4000 data point limit per series
My question is: Is there a way to link the data from Access to an Excel
chart without importing the data (importing would just cause my initial
problem)? I do know some basic...Lost Data #3
I attempted to access my Outlook 2003 this morning and was unable to. It
asked for a new profile. It appears that I've lost all my addresses,
contacts, emails, and calendar/appointment set-ups. Help please, how do I
get this back??????
Crying in the islands.
"oahumannings" <email@example.com(donotspam)> wrote in message
> I attempted to access my Outlook 2003 this morning and was unable to. It
> asked for a new profile. It appears that I've lost all my addresses,
> contacts, emails, and...Data Validation in Excel 2002
I have a workbook with a sheet in called 'Validation'. This sheet is
hidden and contains a number of lists that I use for data validation.
Using previous versions on Excel, I have always defined names for these
lists then on other sheets within the workbook I use the data
validation command using the List option in the Allow field then enter
the name of the list in the Source field, using the option for an
In-cell Dropdown. Upon entering that cell a drop down list was
available populated with the list from my Validation sheet.
Now in Excel 2003, when I attempt the same and look at t...Data migration 03-06-07
I'm in the process of migrating data from a 3:rd party system into MS CRM
3.0. But when I look at the staging database I can't figure out what to do
with the appointments. Although there is an Appointment table in the CRM
database, it seems to be missing from the cdf database. Does anyone knows in
what table the appointments should go?
Also, does anyone knows where to find any detailed documentation about Data
Migration Framework? I've been searching but I haven't been able to find any
You are unable to import appointments w...Off Topic: Pulling Hair Out
Want to have some fun? Search microsoft.public.pos on google groups for
You'll get all of the posts about people pulling thier hair out.
Hint: There's more than one page.
...Data Validation #10
I am using Excel 2003 and am doing a drop down list using Data|Validation. However, I must have the data for my drop down list in the same sheet as my drop down list, otherwise the drop down lsit doesn't work. Am I doing something wrong? I used to be able to put the data in a different sheet. What happened?
It's OK to have the list in another sheet,
but then you must name it, e.g. "List1"
(without quotes), and use that name in
the validation box (Allow: List and enter
Followup to newsgroup only please.
&quo...how i get data homogeneity
there is a formula for that i don't know it
What is the degree of homogeneity you are trying to acheive?
Gary''s Student - gsnu200838
"new user" wrote:
> there is a formula for that i don't know it
"new user" wrote:
> there is a formula for that i don't know it
i have a data and i want know the hohmogeneity for it ; 95 % of the normal
distribution near the optimum point of its chart
Maybe checking a statistics book to find the methodology is step 1. Then we
can help you execute this in Excel
best w...Pull down menu
I am trying find a way to make a pull down menu in excel.
I have a list of foods on one sheet in a workbook where all the nutrition
information is stored per food type where the row indicates the food type
and the columns indicate the nutrition info ie: Carbs, Protein, Fats,
Calories etc. This sheet has roughly 300 or so food items listed in rows.
How can I create a pull down menu in another cell on another worksheet as a
method to select a food item from the food sheet?
Any help is appreciated,
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (...Can you control when the data is saved?
I created a form that allowes add and update. There are several combo box
controls. After a number of the records were added, users bring up the form
and for some reason fiddle/play with the combo box controls. This results in
the data being changed. And they don't seem to realize this is happening.
Is there a way to have Access avoid changing the record unless the user
overtly selects save (or say presses a button to save)?
On Wed, 5 Dec 2007 19:20:02 -0800, JHC <JHC@discussions.microsoft.com>
One way is a trusted one, with very little recidivis...Dividend & Commissions REPORT
Please advise how a report can be generated evidencing all
recorded dividend payments & recorded commission payments.
I am currently utilising Money 2000
...How many data points can you have in an Excel for a Scatter Chart.
I have a customer that has indicated that he can only plot 400 data bites in
an Excel Scatter Chart. Is the correct for Excel 2002 or 2003?
What does a "data bite" represent? What error message do you get?
You should check the XL help topic 'Excel specifications and limits'
specifically the 'Charting specifications' section. One undocumented
limit is that the length of any token in the SERIES formula cannot
exceed be more than about 250 characters. So, if one selects lots of
non-contiguous ranges, it is very possible to exceed that limit.
I was hoping someone could help me please. Here's what I have. A
worksheet that has several dates in a row. D1:T1, Of that range, I
have conditional formatting set to highlight a date(s) either = to or
within the next 7 days.
I need to be able to pull the date next closest or equal to today.
Can anyone help me out?
Any help would be greatly appriecated.
> I was hoping someone could help me please. Here's what I have. A
> worksheet that has several dates in a row. D1:T1, Of that range, I
> have conditional formatting set to highlight a date(s) either = to or...Excel 03 DB query pulls data in wrong order, how to resolve?
New user to Excel DB queries. Have set up DB and query, however query does
not import DB in the column-order of the query. This worked fine the past
couple months. Dont understand why it wont work this month. Have re-created
query and the problem still exists. Cant find any information on how to
troubleshoot this issue. Thanks for your help.
Data>Import External Data>Data Range Properties
Uncheck Preserve column sort/filter/layout
Does that help?
...External data limitation
I apologize for the duplicate post!
We are having trouble downloading 80 fields from a DateTel database into
Excel, and consistently get errors until we drop the fields down to around
60. Is there
a limitation to the number of fields that may be imported into Excel??
IT Services Help Center
Yes there is but it is way more than 80 ....
Unless you are using a trial copy?
John C. Harris, MPA
JCZ Consulting Services, LLC
"Sandy" <Sandy@discussions.microsoft.com> wrote in message
>I apologize for th...Limit data synchronization in Outlook
I try to find a solution to limit all user to synchronize
his own record for security reason in Outlook.
I know CRM have a checkbox for BU only but this check box
can be remove by the user, theire is not a big security...
Did somebody know ISV or something else for that?
...Data into table
When I enter date stright into table, I cant find the record with a query,
only if I enetr the record with the related form.
I paid extra attention no to have any mistakes in trms of spelling etc..
What can cause this?
you've probably just got the wrong where clause man :)
"Tom" <firstname.lastname@example.org> wrote in message
> Hi all
> When I enter date stright into table, I cant find the record with a query,
> only if I enetr the record with the related form.
> I paid extra a...Pivot Table-Change Data Source? Excel 2007
I need to update a series of pivot tables by adding 2010 data. What's the
best way to do so? Add the updated info to the source document and refresh,
or create a new data source and refresh all the tables? Does the new source
have to have the columns in the same order as the previous?
If I create a new source document, how do I tell the tables to change the
source? Other responses to this question say to rightclick a cell and use the
wizard. I'm using Excel2007 and right clicking doesn't produce a wizard.
To change the date source of a PivotTable in Excel...Report Grand Total Miscalculating Overtime
I have a report based on a query that uses the following calculation in a
text box to calculate the total amount paid (including overtime) to an
=([On Std Hours]+[Off Std Hours] + IIF([On Std Hours]+[Off Std Hours]>40, .5*
([On Std Hours]+[Off Std Hours]-40), 0)) * [Employee Data_Rate]
This formula works perfectly to total individual weekly totals. However,
whenever I use the same calculation in the report footer to calculate the
grand total which sums up every employee for the week, the grand total is a
lot higher than it should be. For example, I hand computed the to...Import External Data is missing some data
I have a spreadsheet that pulls data from another spreadsheet. Most of the
data come in fine. However, one collumn is being difficult.
The collumn in question contains dates and comes over blank. If I put alpha
data in the source spreadsheet, though, that WILL import.
Any idea what I'm doing wrong?
Thanks in advance for any assistance!