pivottable refresh #2
I want to proctect a portion of a worksheet that also contains a PivotTable.
Is there a setting that will allow the sheet to be protected and still let
the pivot table be refreshed?
...Replication and the 2 SQL Jobs "REPL-Snapshot"
Replication and the 2 SQL Jobs "REPL-Snapshot".
We have disabled the jobs for 6 months.
>From research my understanding is that these jobs just need to be run
once to create the files in the mscrm/unc....folders.
Once those files are created this job may be turned off.
If any schema changes are made these would then need to be run again so
that changes get reflected on the clients MSDE.
I am after confirmation that the above is indeed correct
The Sync is also very slow . Any advises
...Excel Progrom Error
Happy new year to all.
I often receive the folowing error message in a box titled "Program
EXCEL.exe has generated errors and will be closed by Windows. You will
need to restart the program.
An error log is being created.
The only option is OK which closes Excel. I do not know where the
error log is created.
I am using Office 2000 Service Pack 3 with Windows 2000 Professsional
Service Pack 4.
Can anybody throw some light on this error.
Thanks in anticipation.
What are you doing at the time (i.e. is it consistent)?
----------------...Changing a result ending in 32ths to 16ths i.e. 5 5/32 to 5 3/16
I have a cell where a number (variable) i.e. 10 5/16 which in another cell I
have to divide it in half. The problem is that the number will end with a 32
fraction like 5 5/32. I need that or any other result to end in 16 i.e. 5
3/16. I work in a carton corrugator and we don't use 32ths in measures. We
use 16ths and up. Please help!
In recent versions of Excel:
In older versions:
Microsoft MVP - Excel
"WGL" <WGL@discussions.microsoft.com> wrote in messag...Ask 2 MSFT Experts About v8.0 Security
Welcome to the first Business Solutions Community discussion held directly
in the Microsoft Great Plains newsgroup. During the week of September 20th,
Microsoft Escalation Engineer Kelly Youells and Microsoft Senior Development
Consultant David Musgrave will answer your version 8.0 security questions
directly in this newsgroup thread.
How is this different than any other week in the newsgroup? While product
experts like Kelly and David may frequent the newsgroup during their workweek
to answer as many questions as they can, they don't necessarily *solicit*
questions o...Data Migration Problem #2
This is a multi-part message in MIME format.
I have been struggling with the data migration problem for a long =
time... and get stuck in the middle of the road.
I am importing company data from either excel or text files into the =
cdf_Product table of SQL server (cdf_mscrm database) using the SQL Query =
Analyzer, where a problem is encountered that in the table structure, =
there exists the product id as the primary key (data type: SQLI...Sharebuilder account import error
Invalid .qif header error when trying to import .qif file from sharebuilder
Anyone know of a fix or experienced this problem??
I typed a long mail to sharebuilder regarding this issue...still waiting
fora reply. Hopefully they will be able to help. Microsoft flat out told me
it wasn't their issue and to contact my broker! No help AT ALL.
...Information for Visio 5 users
If you have Visio 5 you should seriously consider upgrading before November
Currently Visio 5 is the oldest version of Visio that qualifies for an
upgrade. When Visio 2003 is released on Oct 21st, Visio 2000 will be the
oldest version that qualifies for an upgrade. At that point Visio 5 will no
longer qualify for an upgrade and you will have to pay full retail price for
a newer version of Visio.
Until Oct 30th, Visio 5 users can upgrade to Visio 2002 and will qualify for
a "free" upgrade to Visio 2003 under Microsoft's Technology guarantee.
(There will be a nominal cost f...Need help w/ excel formula (duplicate entry)
I am not sure if this is possible but I would like
write a formula that would recognize a duplicate entry
under same column.
e.g., column A has heading of Sample ID# and
under is sample ID# in random order. If an entry
of ID is then made but if it is a repeat of the ID that was
previously entered, I would like to it to give some kind
of warning message.
You may want to read some of Chip Pearson's techniques for dealing with
Visit Chip Pearson's site for a Data|validation solution:
http://www.cpearson.com/ex...DPM2010 RC Errors on secondary server.
We have recently upraded our 2007 SP1 Primary DPM server to 2010 RC and it is
I've set up a brand new, fresh Windows 2008 R2 Server for the secondary
server, and have told it to protect one of the protection groups on the
Everything works for a little while, but every half hour or so, the DPM
service crashes and says:
"Connection to the DPM service has been lost.
Review the application event log for information about a possible service
Then asks to restart the administrator console. This kills the ...Adding font (CE 5.0)
I add fonts with plateform builder in my platform project. All seem correct,
but I don't find the files font in the directory windows (Windows or
windows\Fonts). So I'am not able to change the font in my application.
Do i forget something ?
Thanks for help
I have found. I must not use "Raster Fonts Support" from plateform builder
I am using a spreadsheet in Excel 2002 on Windows XP, for some reason the
account numbers (which someone input, along with addresses) have a little
green mark in the corner of the cell. I thought it was to show that there is
a comment, but it is not. When you click on the cell, a little warning sign
shows, saying ERROR - number in this cell formatted as text or preceded by an
apostrophe. When I click on the arrow by the warning sign, it says
Number stored as text
Convert to number
Edit in formula bar
Error checking options
Show formula in audinting toolbar
Now I looked a...owner drawn Clistctrl #2
can any one tell me how to insert item using draw item() function and a
local structure (which contains the data to be inserted)in Clistctrl ??
thanks in advance,
Questio, when I try to open excel or winmx, an error pops
up saying chkdsk, so i ran a chkdsk and it doesnt do
anything. The error also says corrupted file. In excel I
have some important work that I need to open, and it only
opens in Turkish, if I change it to English, its a bunch
of boxes and letters, its not my work I need. How do I
change it back.
What excel version are you using? Try to find somebody with 2003
to see if they can open the file. Otherwise you would look for
some commercial software that might be of help
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B30...Access 2.0 Converter 09-27-04
I have installed the converter for moving from Access 2.0
to Access 2003 running under Windows XP Professional.
However Access 2003 still tells me I need to convert the
database and does not recognise the converter has been
installed, so points me again to the Microsoft Website to
obtain the converter.
Any suggestions please.
My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.
Are you sure that you ran the .exe file for the Access 2.0 Converter so
that it was installed?
To download the Access 2.0 Converter free of charge, visit the following
I have problems on one client that they don't recieve all emails from people
sending to them. I guess something is wrong in the configuration. When I do a
nslookup -type=mx domain.com I just get unautharized answer. Also the ttl
time is just 1800 when I do a dns report. Do the guys that handle the dns
The people that doesn't get their mail throw get the 4.4.7 error in return.
Ed Crowley MVP
"There are seldom good technological solutions to behavioral problems."
I am receiving the following error messages, please assist
Could result be sent to email@example.com
Your server has unexpectedly terminated the connection. Possible causes for
this include server problems, network problems, or a long period of
inactivity. Subject 'brocolli & mushroom stir fry noodle', Account:
'pop.gmail.com', Server: 'smtp.gmail.com', Protocol: SMTP, Port: 995,
Secure(SSL): Yes, Error Number: 0x800CCC0F
Your server has unexpectedly terminated the connection. Possible causes for
this include server p...delete server...routing master error
I have 2 exchange servers (exch 2003) and i have to delete
one of them.
I changed all replication etc...(before we had also a 5.5
which is already removed) but when i stop the services and
try to remove the server via system manager of my second
exchange (the one that will stay) i get an error message
that my server that i want to delete is the routing master
for that group.
How can i make my other server the routing master ?
i don't have any site replication (deleted it because not
Go to routing groups > first routing group > mem...Excel error codes translations
Does anybody know where I can find a kind of dictionary for Exce
The problem is sometimes I get an error message that is not in Englis
and without error code and then looking for the solution I must kno
its equivalent in English.
Message posted from http://www.ExcelForum.com
...toolbar, date, services, errors, paste, minimized system restore doesn't work
I have a XP system that the toolbar does not show open programs, services do
not seem to load at boot, the date is off by one month, I cannot paste
anything that I copy, and system restore does not work. All of these issues
started at the same time a few days ago. Has anyone else seen this group of
errors? I am trying to resolve and do not know if it is a system update
gone bad, or if maybe it is a viruse/malware issue. Please let me know if
you had had these problems together and what you did to fix them.
There is a very good chance that you are seeing the effects of a hi...Re: Money 2004
Thanks for the suggestion. I tried unregistering/re-registering the msxml3
DLL, but still no luck. However, knowing the help file topics are local
might help with debugging this problem.
"Randy" <firstname.lastname@example.org> wrote in message news:...
> I've recently upgraded to Money 2004 Premium from 2003 Deluxe. I'm now
> finding that I can't view any help topics--I get the "Unable to load
> Click here to try again." I've tried all the suggestions posted here and
> other sites: cleared out temporary in..."File Error: Data May Be Lost" error when opening workbook saved in Mac
When I open in Excel 2007 for Windows workbook with charts saved in
Mac OS, I see the message "File Error: Data May Be Lost".
In Excel 2003 for Windows this message appears as many times as many
sheets there are in workbook.
Maybe someone knows what's the reason?
Unfortunately you haven't provided the info needed... "Mac OS" means very
little. The question is "What version of Mac Excel are you using, what file
format are the files saved as & what type of content is in the files?"
In general, what you're running into is that Excel 2003 &a...Visual Studio 7 project subfolders #2
I know this may not be the exact group to ask this in, but in VS6.0 I
used to be able to create subfolders within a project to keep my
classes divided up conveniently. I just got VS7, however, and i can't
seem to find any way to create subfolders. I can create subfolders for
an entire SOLUTION, but not within a project. Am I missing or
forgetting something here?
AMEX and Discover are not being sent over to the credit card processor during
settlement. I comes up with a "TECHNICAL ERROR". Visa and MC are settling
fine. Does anyone know what the problem is?? All are setup as different
tranaction types in RMS and ALL authorize fine during the transaction process.
Your merchant account is not correctly configured for AMEX & Discover. This
is on the bank's side, not RMS.
Tiber Creek Consulting
Please DO NOT respond to me dir...CObject Private method access error
I am trying to recompile application that has been developed in VC++
6.0 with VC++2005..
While compiling, I'm getting the following error..
error C2248: 'CObject::CObject' : cannot access private member declared
in class 'CObject'
1> c:\program files\microsoft visual studio
8\vc\atlmfc\include\afx.h(553) : see declaration of 'CObject::CObject'
1> c:\program files\microsoft visual studio
8\vc\atlmfc\include\afx.h(524) : see declaration of 'CObject'
1> This diagnostic occurred in the compiler generated function