Defraging a pst file
When I try to defrag my HD the pst file never defrags.
Is there a way to force it to defrag the pst file?
Defrag doesn't operate on files per se, it runs defragmentation of a disk,
optimizing file storage by moving the little bits and pieces of files to
contiguous spaces on the disk.. Database files, such as Access, Outlook,
etc., need to be compacted/compressed to remove whitespace.
You can compact your PST file by right-clicking on the top-level folder,
going to properties, advanced, compact now... this will only make a
difference if you've deleted a lot of items and ...About opening .wmv files on MacBook laptop
I have a MacBook laptop computer. It is running OS X 10.4.11.............my
friends often send me emails with .wmv files attached. I have not been able
to open these files. Can anyone help me with what I would have to do to be
able to open these windows files on my MacBook. Thank you
> I have a MacBook laptop computer. It is running OS X 10.4.11.............my
> friends often send me emails with .wmv files attached. I have not been able
> to open these files. Can anyone help me with what I would have to do to be
> able to open these windows files ...Today Conditional Format
I have a column which calculated a date based on 3 working days from a date
input into a diff column. What I want to do I have the calculated date
appear bold if that date has passed based on the current date.
For example if I input 01/08/11 the next column calculates 04/08/11 (3
working days). I want the caluclated date to appear bold when I open the
spreadsheet on the 05/08/11 ro show the calculated date has passed.
I can use conditional formatting but can't get the syntax right
Win XP Pro
Andy Roberts presented the following explanation :
> I ha...combine 4 file into one
I have one excel file. This file consists of Item Number,
Description, Quantity, Unit Cost and Extended Value. I
send this file to 4 users in various locations so they can
open in the MS Excel. The users will count how many
quantity they have for each Item number. The user then
saves and sends the file back to me.
My question is how do I combine four files from 4 users
back into one file with the quantity update and other
fields remain unchanged. For instant, User A count 4 for
the item 12345, User B count 2 for the item 12345, User C
count 1 and User D count 0. How do I combine 4 files f...Display the complete URL instead of a link
Output from one of my software is in excel format. The results are
Name Title ID source score
ABC rock-n-roll 123 link 92
ABC2 rock-n-roll2 124 link 65
ABC3 rock-n-roll3 125 link 45
The "link" in the source column has the actual URL to that album or
file. For further processing I need to import this file as a csv and I
need the actual URL displayed in the source instead of the "link" word.
For example the URL is www.somewebsite.com/documentID=AA1234
some basically I want something like
ABC,rock-n-rol...Publisher 2002 won't open or insert any pic files
Got new computer...running XP professional...reloaded my publisher 2002 and now it won't import any of my .eps, jpeg, files, etc. Dialog box comes up and asks what to convert the file from. It never did this before. Any ideas???
Have you installed the Publisher 2002 Service Releases.
Sounds like you have not.
go to http://officeupdate.microsoft.com
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from ���MS�Publisher��� <email@example.com>...
> go to http://officeupdate.microsoft.com
Or even to http://office.microsoft.com
Ed Bennet...Transferring mail files (dbx) from outlook express to outlook
Recently upgraded computer and need to transfer old mail
in outlook express, .dbx files, to MS Outlook. How do I
Does OE currently recognize them? If so, you can use OE's File menu > Export
"Steve" <firstname.lastname@example.org> wrote in message
> Recently upgraded computer and need to transfer old mail
> in outlook express, .dbx files, to MS Outlook. How do I
> do that?
...Can t read mac-word files containing excel graphs on a PC
I am using microsoft Office X 10.1.4 on a powerbook G4 with operating
system OS X 10.3.5 panther.
I have created a graph in Excel on its own sheet (ie the one that
contains the relevant data).
I activate the graph, copy it to the clipboard, switch to Word and do
a Paste Special, paste as image.
So do I with all the excel graphs I want to insert into my word
document (scientific report).
The word document is saved under format "microsoft word document".
I ve sent my word document to several colleagues who work on PCs. They
all told me they could not
see the excel graphs. They (the ...Two Condition Vlookup?
I am currently trying to create a function that searches through an
array for two exact column values which allows me to retrieve a third
column value. For example:
Type of Fruit Date Packaged Amount of Fruit
Apples June 100
Oranges June 50
Apples July 75
Grapes July 50
In this example, I would be looking to retrieve the Amount of Fruit
(Apples) that was packaged in July. I would be putt...when I open excel file,changes was undid-excel 2007, compatibility
I have a file that was made in excel 2007 working in compatibility mode and
when I change format in some cell (for example font size), then I save
changes and after reopen this fiel the changes was undid.
Can some help me?
Sorry for my english isn't very well
...Embedded Word files in Word files do not open...
Operating System: Mac OS X 10.6 (Snow Leopard)
I have ~1000 pages of class notes that I put together in Word 2004 (and earlier) in which I embedded pictures that I created in a word document. (This was done via the "Insert-Object-Word Document" function.) When I try to open them in Word 2008, I get the spinning wheel of death. Any suggestions? I really need to be able to open them so that I can change things and improve the figures and notes. <br><br>I still have both Word 2004 and 2008 on the computer. (As well as XP with 2...Query condition by date range
I'm trying to create a query to base a report from. I need it to return
records within a date range that needs to be specified, as in specifying the
beginning date and having the current date as the end date. A field is
included in the query that has listed dates in the format mm/dd/yyyy. How
would I write the criteria? I have part of it ready - [Please enter starting
date:] . I know that's how you get the little question window.
On Tue, 4 Dec 2007 14:51:00 -0800, silva wrote:
> I'm trying to create a query to base a report from. I need it to return
> records within a...End User Recovery
Before DPM we used Shadow Copy on our windows servers.
We were able to right click on a file or folder, pick previous versions and
gain access to the shadow copies.
Now that we have DPM, this seems to have changed.
We can right click on a folder and see our previous versions, but if we try
the same on a file we just get no previous versions available.
Is this correct?
If you go on a folder, you will always see "previous versions"
A file will only show you "previous versions" if there are actually previous
...Need help with conditional formula (Excel 97)
Can anyone give me the correct syntax for the following formula:
if A1 is blank, and B1 is more than zero, then display B1, otherwise
display nothing (blank cell)
met vriendelijke groetjes
"Jake D" <JakeD@djhtend.com> schreef in bericht
> Can anyone give me the correct syntax for the following formula:
> if A1 is blank, and B1 is more than zero, then display B1, otherwise
> display nothing (blank cell)
> Thank you
> ...Conditional formatting if condition of an if statement is true and a string value is displayed
I got a nested 'IF'-Formula in an excel cell that returns nothing if
the condition is false.
I would like to conditionally format this cell with grey shading if
the condition is true and a string value is displayed.
How can this be achieved using excel conditional formating
Help is much appreciated. Thank you very much in advance.
Let's say your doing this conditional formatting in cell K17. In
conditional formatting (xl2003) choose the FormulaIs: option and enter:
choose your formatt...file browser dialog
I need an utility let me to browse local and network folders from access
2000 and return the 'file' selected from the user.
I've found this http://www.mvps.org/access/api/api0002.htm but return only
folder name, not file name.
what can I do?
On Wed, 2 May 2007 16:03:42 +0200, "massimo" <email@example.com> wrote:
>I need an utility let me to browse local and network folders from access
>2000 and return the 'file' selected from the user.
>I've found this http://www.mvps.org/access/api/api0002.htm but return onl...Blocking File Attachments
Is is possible in Exchange 2003 to scan for and block certain file types or
do I need a 3rd party program? (.exe or .zip, etc)
most AV products will allow you to do this...you do have Exchange-aware AV
on the server/s, right?
Susan Conkey [MVP]
"dlove106" <firstname.lastname@example.org> wrote in message
> Is is possible in Exchange 2003 to scan for and block certain file types
> do I need a 3rd party program? (.exe or .zip, etc)
I do have exchange-aware AV, I was won...Conditional Field in Queries
Is there a way to make a field in a query conditional so that it only
displays the value if the value is equal to something specifically
> Is there a way to make a field in a query conditional so that it only
> displays the value if the value is equal to something specifically
> set? Thanks.
Explain "the value is equal to something specifically set".
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
...Custom Link for UPS tracking number?
Does anyone know the correct link for UPS to pull up tracking number info
from sales orders? I've tried several that open the UPS site when I click on
the tracking number link from SOP, but none that actaully fill in and pull up
the tracking number entered on the order. Thanks.
Thank you for the post to the Microsoft Dynamics Newsgroups!
There is a way to have it automatically populated the tracking number on
the web sites.
When you set up your custom links web pag...How do i use Conditional formatting for 3+ conditions ?
I have a text box in a report which highlights in colour current members in
a list of past and present member names. I have six types of current members
that I want to highlight, but with conditional formatting I can only use 3
conditions in the members [Type] field. I have tried [Type]="Full member" Or
"Life member" but the "Or" doesn't work ! Is there a way to do this ?
thanks .. Roger
CF is limited to 3 contitions, but you can use OR in those expressions.
If you set Condition1 to Expression, you can use:
([Type] = "Full member") Or (...can't find desktop image file
The image file that I have displayed on the desktop is nowhere to be found.
When I go to control panel/display/desktop/background ---- the image file is
one of the choices in a drop down menu. I wish to copy this image file to
another computer but I can't locate it on the computer?? I've tried a
"search" but no luck.
> The image file that I have displayed on the desktop is nowhere to be
> found. When I go to control panel/display/desktop/background ---- the
> image file is one of the choices in a drop down menu. I wish to copy
> this i...Help with Conditional formatting with Dates
I have a spreadsheet in which I have to monitor various dates which are in
different columns (i.e. (1) Date Tender Released, (2) Date Company Selected,
(3) Date Draft Contract Forwarded, (4) Date Contract Signed etc...).
Would if be possible to Conditional Format and have diffirent ROWs
highlighted for each individual Contracts (I have 300 running contracts
running) every time a date is filled in these different columns:
Initial Step (1) = Yellow (Call for Tender released)
Step (2) = Blue (Company Selected)
Step (3) = Brown (Contract under Process)
Step (4) = Green (Contract Si...Link Order , CRT MFC
I'm getting a linking problem.
nafxcwd.lib(afxmem.obj) : error LNK2005: "void * __cdecl operator
new(unsigned int)"(??2@YAPAXI@Z) already defined in LIBCMTD.lib(new.obj)
nafxcwd.lib(afxmem.obj) : error LNK2005: "void __cdecl operator
delete(void *)"(??3@YAXPAX@Z) already defined in LIBCMTD.lib(dbgnew.obj)
I googled a found that the cause is a wrong link order of the mfc and
the crt lib. (I have to link static)
How do I fix this problem, I mean how and where do I fix the link order
in VC++ 2008.
Not sure about 2008, but in 2005 Project/Propert...Word 2008 file error
I continue to get the same message...A file error occurred. Check your network connections or make sure the disk is properly inserted and not defective. (Normal.dotm) I have reinstalled office twice and continue to get this issue in Word.
What are you doing when this error comes up? Launching, opening a file?
What happens after you hit OK to the error?
Also, state version of Word and OS.
Without such details, it's unlikely that anyone can help.
> I continue to get the same message...A file error occurred. Check your network connection...Recovering replacement file
Is it possible to recover a file that was replaced? I deleted a document,
went to the trashcan and hit recover, then realized I replaced it over the
CORRECT document, is there any way to recover this or am I screwed? It was
15 excel pages!!! HELP!!!
Unless you have a backup you cannot recover it sorry
> Is it possible to recover a file that was replaced? I deleted a document,
> went to the trashcan and hit recover, then realized I replaced it over the
> CORRECT document, is there any way to recover this or am I screwed? It was
> 15 exce...