Show whole Table of Contents for Excel Help
It would be nice if users could easily find the whole table of contents for
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 you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
Does anyone know of a good site for explaining basic Exchange admin
issues. Kinda new to Exchange and would like to nail down some basics. One
issue at hand right now is to some how retrieve mail that a user has
deleted. If I remember correctly there is a timeout period from when the
user deletes a message and when the server actually deletes it. Any help
would be much appreciated!
If Deleted Item Retention is enabled on the Exchange
Information Store and the user is NOT storing their email
in a PST then you'll be able to use the "Recover Deleted
Items"...Need to delete pending MS updates
A friend asked me to help him with his computer.
So I went and started applying the updates to his XP machine.
Well it turns out that he has a VERY small drive and even less memory :-(
I have downloaded some MS updates but there is not enough room to run them
let alone let them just remain on the drive
Where are the pending updates located so I can go and delete them?
Start > Run > type in, press Enter or click OK after each command
net stop wuauserv
net stop bits
Show hidden files, folders, and system files:
Hi everybody !
We have just make some mappings in our MS CRM environment from Accounts to
Contacts and we've got the "Duplicate Error" message.
I've check the group's archives to find a solution in the kb 862493 but it
doesn't solve the problem.
I still have the same error.
When I compare the Dev Environment and the Production environment, I can see
a lot of difference in the existing mappings.
It seems than MS CRM create its own through the life of the application.
So there are my questions :
* Does it exists a default list of the mappings to go back to a &qu...Deleting CRM User!
I am looking to find ouit how one can delete a CRM USer
and have the license go back into the pool of unused
licenses. I can only find a way to disable the account.
The users that I wanted to delete are in the disable user
account view right now but I need to delete them and I
need the licenses.
I do not believe that you can delete using the supplied interfaces. You
simply remove the license as stated below. If you were to remove or delete
a user, there could be many orphaned entities.
"Joseph Michaud" <firstname.lastname@example.org> wrote in message
news:#Qfbbc7UDHA.964@TK2MS...Signature Images have wrong path. Editor error in Rich Text or HTML mail
This is a multi-part message in MIME format.
Myself and many others have long been plagued with the "RED X" syndrome =
in Outlook and Outlook Express when an image is not encoded and sent and =
shows up as a "image not found" Red X icon.
I have now discovered a method to duplicate th...Question: How to delete the email history which created by workflo
The whole process is:
When a case has been created for 1 hour but not be closed, then the workflow
will send an CRM email to the case's owner for notify.
After sent an email, there will be a email history in the history, But we
don't want to save the email which created by workflow.
How can we do that?
...Delete a Closed Invoice
is ther anyway i can delete a "Closed" invoice? one of the user accidentlly
close the invoice by selecting "paid in full". Now , the invoice are mark as
read only and we can delete it.
It is possible to go into the DB and delete it manually from the InvoiceBase
and InvoiceDetailBase tables, but I wouldn't recommend it.
You can also manually change the StatusCode and StateCode fields in the
InvoiceBase table. Look at other values used in the InvoiceBase table as
examples of valid states. Once it's not closed, you can edit/delete it
again through th...My delete file is autmatically being deleted every 7 days. Why?
This just started and I dont know why. Thanks
Neither do we.
We have no idea what you are asking.
Try again. Do not hesitate to use accurate details.
"Denny" <Denny@discussions.microsoft.com> wrote in message
> This just started and I dont know why. Thanks
Your deleted folder is being emptied every 7 days? Are you using autoarchive
to do it?
Are you using exchange server? If so the admin could have configured it on
Diane Poremsky [MVP - Outlook]
Outlook ...Delet page in publisher wont delete
I cannot delete the pages I want in my publication. When i press edit, delete
page it will not delete the pages. I have no problem deleting any of the
other pages though.
Turn off the two page spread and try again.
Mary Sauer MSFT MVP
"pippy6" <email@example.com> wrote in message
>I cannot delete the pages I want in my publication. When i press edit, delete
> page it will not delete the pages. I have no problem...Making items inactive as opposed to deleting them
I have read that it's bad to delete items, and I think I found that true
because I went back recently to look at a prior sale and it wouldn't pull up
any info on it cause I had deleted the item in question.
So, I went in and made a few items inactive to try it, and now I can't find
them. Sorry for being an idiot, but how do I access the inactive items in
Couple things you can do is run an item quantity report and filter for
inactive = yes....you can also run an inventorry wizard task "set items
active" it will show you the items that are flagged...Pubs Keep large file size after pages are deleted
I am using Pub 2003. I have a quick reference guide that has 123 pages with
graphics the size of the document is 72,503 MB. I deleted everything except
17 pages but the document size is STILL 71,881 MB.
In previous discussion groups I found the two links listed below. I looked
under Objects > Design Gallery Object but I have only 3 tabs, Objects by
Category, Objects by Design, and My Objects. I looked at any "options"
buttons but could not find a tab called "Extra Content".
"PUB2000: Publication Retains Large File Size When Pages Are Deleted
http://support...Money 2001 Deletion #2
I CAN'T DELETE/REMOVE MONEY!!!! I lost the disk and was
having problems with the program so bought 2004. 2004
say's it sees the old version and I must have the 2001
disk in order for it to finish install. I stopped install
and tried to remove through Windows, only to have it tell
me that I need the disk. I called Customer Service, and
they were completely incompetant and unable to help me do
anything but realize microsoft has terrible support
options. I just want to get this worthless program off my
I'm just going to keep calling microsoft every...Delete transactions w/out deleting POs
Is there a way to delete training transactions without deleting Purchase
Orders. I found out the hard way that using Delete Transactions in SO
Administrtor also deletes POs.
Thanks in advance - Bob
...delete a cell
I am trying to delete a single cell, but the worksheet does not allow me to do it. I have a choice to delete the whole row or the whole column. I just need to move cells up. I know I must have to set an option, but can't figure out which?
"tatty" <firstname.lastname@example.org> wrote in message
> I am trying to delete a single cell, but the worksheet does not allow me
to do it. I have a choice to delete the whole row or the whole column. I
just need to move cells up. I know I must have to set an option, but can't
f...Possible to have same footnotes from 1 table appear on 2 pages?
1. I have a table on a page in landscape format which spreads over 2 pages.
2. I have enabled the table top row to "repeat as a header row at the top
of each page". This header row has footnote references.
3. The footnotes, however, ONLY appear on the first page and NOT the second
4. Is there a way to make the footnotes appear on the first AND second page
Thanks! This is driving me nuts.....
> 1. I have a table on a page in landscape format which spreads over 2 pages.
> 2. I have enabled the table top row ...how to delete a row in excel with a specific word using visual basic
I have an excel file that always come with a line at the end with
"downloaded:" in the cell. How can I write a macro to search for that
cell and delete the row that cell is in?
Thanks for all your help!
Any time you are in doubt on how to interact with excel, try recording a new macro and then physically do the steps you are trying to code. Stop the recording and then go look at the recorded macro
Hi "mchen" email@example.com,
Delete rows with "N" in Column 31 (col AE)
from my http://www.mvps.org/dmcritchie/excel/delem...GP Client Error
After installing SQL 2005 SP-2, any new GP Client Installation is giving
error that "The database version is different then the client version"
Any Help Please?
Are you sure this was due to the installation of SQL Server 2005 Service Pack
2? It sounds like your error stems from installing a newer version of a
Dynamics GP Service pack that has not been applied to the client computer
Could you please confirm this is the case?
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
"create_share" wrote:...Error Messege: Ox80042110
I recently upgraded to Outlook 2003. I am receiving this error message.
Your POP3 server is providing inconsistent information. Number of messages
returned by STAT Command does not match the number of items returned by UTDL
or LIST commands. I am able to send a message but cannot retrieve my
messages. Any ideas about how to fix this problem?
gjmar <firstname.lastname@example.org> wrote:
> I recently upgraded to Outlook 2003. I am receiving this error
> message. Your POP3 server is providing inconsistent information.
> Number of messages returned by STAT Command doe...non-numeric fields in pivot table
I'm trying to create a pivot table, but the data I'm
trying to display is non-numeric. Row headings will be a
feature number, column headings will be a customer, and
the data displayed will be text, eg Q1FY03, Q2FY04, etc.
But it appears all of the pivot table options are confined
to numeric calculations like sum, count, max etc. Is
there a way to just get a pivot table displaying the text
data and not the count, etc?
The data area of a pivot table can't show text. Perhaps you could create
a table on the worksheet, and use formulas to return the data.
Or...deleting multiple records from access
I have a simple database with about 500000 records
I want to know if there is a way to quickly erase a large number
of records at once, using access. I want to mark and then delete,
but I can't mark a large number of records
Is there some logic as to which records you'll keep, and which you'll
If so, then you could develop a Delete query that would do that for you.
Are you deleting all of them?
If so, just delete the table.
What do you mean by "mark?" Do you mean use the Record Selectors
in tabl...A get/change first operation on table 'POP_Rec_Opt' cannot find the table
Please help. It is urgent!
I received the following error when I do purchase goods receivings
A get/change first operation on table 'POP_Rec_Opt' cannot find the
...Deleteing columns in Excel 2007
In previous versions I was able to delete non-adjacent columns, but
this version seems not to allow it... When I choose non-adjacent
columns, the option for deleteing them is greyed out. I looked it up
in help, which wasn't very helpful, checked Excel preferences, just in
case there's a setting that might allow that, again to no avail.
Is there a way to do it in this version?
I suspect your sheet is protected.
Right click on the sheet tab>Unprotect.
With unprotected sheets deleting non-adjacent columns works the same in
XL2007 as in earlier versions.
For some reason I have not seen anything of my previous attempts to post
this question - so a last go.
Outlook 2000 -
Is it possible to change a setting so that deleting a message
permanently deletes it rather than moving it to the deleted items bin?
I don't have Outlook 2000 in front of me (I don't maintain VMs that go back
that far) but if you go to Tools | Options | Other | Advanced(?) you will
probably find a setting that's relevant.
Ben M. Schorr, MVP
Roland Schorr & Tower
Author: The...deleting a fields content
I have a situation in which a user will need to delete only the content of
one field for a record. For each record in the table there is a column
(field) called IsChildOf. On the webpage there will be a button that will
delete only the content (a number) of the field IsChildOf for the record.
So, if record ID 449945 has 25 in the IsChildOf and the person uses the
delete button, the 25 is deleted.
How is the DELETE statement constructed for something like that (I'm a noob
> On the webpage there will be a button that will
> delete onl...