Failed move data for ISV Config
I have seen this issue on the MS Knowledgebase and on the newsgroup, but my
problem seems a bit different. I did a fresh install of my laptop along with
the CRM 4 Outlook client. When I try to go offline, I get "Failed to move
data for entity 'ISV Config' during action Insert, countRows=1."
I have seen similar issues posted with specific entities noted - but the ISV
Config seems different from what I have been reading. I followed the KB
article, but still the same problem. Any suggestions?
Thanks - JM
..."Link to other data source"
When I open my workbook, I get a message asking if I want to update the links
to other data sources but I can't find any formulas that reference another
I copied a sheet from another workbook into this workbook and thought I
updated all formulas, but obviously I missed one and can't seem to find it.
Any suggestions for quickly finding the formula that's causing this?
what version of Excel are you using? If 2003, you can select Edit - Links to
view all linked documents associated with the one you are viewing. You can
select a linked document and click the &qu...SQL Data transfer to a Contact Public folder
We are trying to find a way to get Data from SQL to a Contact Folder in
Public folders on ex 2003 sp1. We can do anything necessary to the SQL data
but getting it into Exchange Publis Folder in the hard part. We really would
like to automate this task since the Data in the SQL is updated regularly.
Any ideas are welcomed. We have used basic pst imports and etc. We need
something with more flexiblilty and automation, like a DTS package transfer.
...Upgrade warning with CPY tables
This one company of many always gets a warning during table update. It is
with tables CPY30250, CPY30150, CPY50250 and CPY40205.
It says The table does not exist in the database. Recommended Action says
"This is not a problem unless this table really exists but was not found
because of path problems".
These tables DO exist. This company does run Canadian Payroll with no
Is this something that can be fixed? I am upgrading to GP 10.00 (from
9.00.0337) this weekend.
I am not entirely in tune with Canadian Payroll tables, but if you run the
I have a pivot table. The columns are month and rows are sales people.
I want to display the grand total for the current month from the pivot
table in another cell. The pivot table is based on a named range so the
grand total line may not always be in the same row. Is that even
possible? If so could someone please point me in the right direction.
Use the GetPivotData function - which will adjust to where the value is
For more information take a look at
> I have a pi...Scrape a website tet string into access table
I'm try to search some websites for a string which, if found, will be added
to a table along with a time stamp.
On some sites this works and other it doesn't. The vba code hangs up a
different points in the process no matter what I try.
Even something simple such as
Create IE object
Close IE object
Is this as IE problem or Access.
There is very little help on this subject around.
Sorry but you will never get this to work (other than the open IE Object).
This has nothing to do with access or IE.
Some website "REALLY" do...Needing help automatically generating info from a table to a form
I'm creating a database for a project at work and I'm a little rusty with
Access 2003 so any help would be greatly appreciated. I've started with a
table that I have imported from Excel that contains the employee's clock
number, their name and their supervisor in respective columns. I would like
to create a form that has three boxes. The first is a box that allows the
user to key in (or possibly select) an employee clock number. Once this is
completed I would like for the employee's name and supervisor to
automatically appear underneath the first box. I'm ...Data Validation Dropdown
we are using Excel 2002 with one sheet has some data validation dropdow
allowing a list of value like "A,B,C,D". it had been OK then all o
sudden all dropdown lists disappeared even though the data valiadatio
object are still there.
there is doc'ed problem in MSDN for excel 97 with freeze pane but i
doesn't apply to our situation.
I remove all pane and pagebreaks, still dropdown list doesn't show.
any help appreciated
MS programmer for financial industr
jliu2000's Profile: http://...Pivot Table Report
I have a pivot table linked to an Access database. I want to sum 2 of the
I already have them in the data area (where summed data should be).
I'm trying to sum the 2 colymns at the bottom within the pivot table area?
...Making a Logarithmic Graph
I'm somewhat of a newbie in terms of using MFC and I'm continuing work
on a project that already has a linear graph class. What I need to do
is implement a logarithmic graph.
I know that there is no short-cut for making graphs with MFC and that's
why the linear graph class draws everything manually. I would like to
know how anybody here would proceed to achieve this.
I have a basic idea of how the scale might be made but considering the
pre-existing graphing architecture that allows the user to rescale the
linear graph. Jumping into this seems overwelming considering all the
p...Excel data to Word for Mail merge
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline; modification-date="Tue, 5 May 2008 05:45:46
Content-Ty...Chart Data Table, Data Range, etc. do not update on Chart
I have two Excel Workbooks. Workbook 1 contains the data and a line chart. Workbook 2 contains just a line chart of the same data as in Workbook 1. I copied the line chart from workbook 1 to workbook 2 using copy/paste. If the amounts change with in the existing data range then both line charts (workbook 1 & workbook 2) update fine. However, when I need to change the range of the data to include more cells only the line chart in workbook 1 is updated. The line chart in workbook two does not reflect the changes to the data range made to the line chart in workbook 1. What is the best ...getting information contained in the design table to an excel spreadsheet
I am trying to copy the fieldname data and data fields to
an excel spreadsheet. using the copy function in access
does not provide a paste option in excel.
I'm new to this so theres probably a simple sollution but
i cannot find it in the help instructions
While in Access - With the desired Table Open, Click on the menu Tools,
Analyze it with Excel. Done.
"jimh" <email@example.com> wrote in message
> I am trying to copy the fieldname data and data fields to
> an e...which chart/smart art to use to show this data in power point 2007
CHC is referral unit for 4 PHC's.PHC is a referral unit for 6 sub
centres.There is one sub-cenre for every four villages...
There are total of 175 CHC's and 1500 PHC's .
Sounds like an org chart to me. But that's a lot of info to try to put onto
an org chart on one slide. You could span it over slides if it's important
for the audience to really see all that info. Somehow I don't think it is,
though. You need to decide what the point you're trying to make is.
Maybe it would be better to show dots on a map and just say that one CHC
refers to ...Shrinking Graphs in Excel 2007
We have a particular issue with some spreadsheets and shrinking graphs on
each 'save as'. As they have older VB code, we can’t save it under excel 2007
format and need to always save under 97-2003 format. This issue only started
occuring in the last month or so. It occurs on all PC's and for all sheets.
Is anybody aware of this issue or know if a hotfix is coming out?
Sean, there have been other postings on shrinking graphs (you can see for
yourself in the Search facility).
I wouldn't hold your breath for a hotfix.
"seanpottinger" w...Data fit
I need to fit some data points to a function: y = A.(1 - exp(-B.x))
and get the best-fit values of A and B.
It seems excel comes with some push button fitting functions (linear,
polynomial) but not custom ones. Is this the case? If so, what do
people generally use to fit their data?
Put trial values for A and B in two cells.
Create a new column with an estimated value (based on the A and B cells)
for each observation in the data set.
In another cell, calculate:
- the sum of squared differences between actual and estimated
observations (for least squares estimation) or
-...Data Point Label
I am trying to create a scatter plot in excel based on the
following data set.
X-Axis: 1 2 3 4 5 6 7
8 9 10 11 12 13 14
Y-Axis: 10.5 11.5 12.5 13.5 14.5 15.5
16.5 17.5 18.5 19.5 20.5 21.5
22.5 23.5 24.5
Everything is fine upto this point, I get the plot with
points labeled by the values from Y-axis. But what I want
is to label them by the following:
Labels: A B C D E F G
H I J K L M N
I could not find any option to pass a set of labels in
excel charts. Any help is highly appreciated.
You can use Rob Bovey's XY Chart Labeler to add the labels. It...Converting lists to tables
I have a list of addresses that I should like to convert to a table, they
each contain 4 fields, as follows:
I should like to convert these names to:
John Doe 123 Street Anywhere Anytown
Bill Bloggs 456 Road Somewhere Someplace
The list contains several hundred names and addresses so idealy I would like
an easier way to do this that repetitive cut and paste.
Assuming the list is in column A.......
In B1 enter =INDEX($A:$A,(ROWS($1:1)-1)*4+COLUMNS($A:B)-1)
Copy across to E1 then copy B1...retrieve information from table
From the table below i want to retrieve for example the figure "6" (6 i
input in another cell) and put the outcome somewhere else on my sheet i
the following order:
input: 6 (for example =b1)
How can i retrieve an input number from a table and put the results a
above somewhere else (bookings and fee are the names of the x-axis an
Hope there is somebody who can help me! Thanks ;)
1 2 3
2 2 4 6
2,1 2,1 4,2 6,3
2,2 2,2 4,4 6,6
2,3 2,3 4,6 6,9
2,4 2,4 4,8 7,2
2,5 2,5 5 7,5
2,6 2,6 5,2 7,8
2,7 2,7 5,4 8,1
2,8 2,8 5,6 8,4
2,9 ...Re: MICROSOFT MONEY 2005
I'm assuming you converted 2004 file to 2005. If this is so, money will generate a backup of 2004 before converting.
Do a search for a file ext *.m1? or *.mn?
<<Okay MVP's. I concede. Like John Kerry, I admit defeat. I should
have backed up the Money 2004. I should have backed up my data.
Still, does anyone have a fix to this problem? I guess it's happening
to hundreds of people. Anyone hear an answer yet?
Having difficulty creating a report that involves multiple tables in Report
Wizard. Followed step-by-step instructions in book...doesn't work. Unable
to locate solution/answer to question on Help...?
You'll find you have much more flexibility in creating reports if you use a
query to connect all the tables together you need in your report, then base
the report on the query, instead of trying to connect the tables directly
for the report.
Microsoft Access MVP
Disclaimer: This author may have received products and serv...collect data from mail merge
If I create a mail merge in Word with some blank space for data entry, can I
collect the feedbacks from returned word file, and consolidate them in excel ?
Can you give a little more information about what you are trying to do.
Excel is a pretty powerful tool; almost certainly you can do what you want.
If this information was helpful, please indicate this by clicking ''Yes''.
"data collection" wrote:
> If I create a mail merge in Word with some blank space for data entry, can I
> collect the feedbacks from returned wo...how to prepare 3 dimension graph in excel
I am trying to draw a graph in X, Y, Z axis but cant get throught, I was
sucessful in drawing in two axis X,Y can any one help me in this.
This might help.
"Som Chatterjee" <Som Chatterjee@discussions.microsoft.com> wrote in message
> I am trying to draw a graph in X, Y, Z axis but cant get throught, I was
> sucessful in drawing in two axis X,Y can any one help me in this.
Andy Pope offers this approach as well:
http://andypope.info/charts/3d...SQL Table conflicts? 1.2-3.0 upgrade failure?
I am trying to track down why I cannot upgrade from 1.2 to 3.0.
Since I know little about SQL could someone please help me understand why
there are about a dozen conflicts in both MSCRM and METABASE tables?
The conflicts look something like
(about a dozen more)
There are a similar entries in the MSCRM table.
I have tried going offline/online with all the clients to see if that clears
the conflicts. What I find curious is that all the dates are creation dates
of July, 2005 when some customizations were done.
I get an "Action Mi...Charting data from many files
I have a weekly summary archive that I do of our cash flows. I would like to
make a chart that shows the change in different account balances over the
last year. Every single file is done in the exact same format -- same pages,
same columns, etc.
Is there a way to get this information together without having to go into
every single file?