Copy Public Folders
Is there a way to copy/export the public folder(s) to local drive?
you can drag the items in the folder to a folder in a pst file or a folder
on the hard drive.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
"Eldingo" <email@example.com> wrote in message
news:ezZrOlF9JH...Are there any household budget templates available in Excel?
Are there any household budget templates available in Excel?
Do a search near the top for "Budget," and you should find a few of them.
Looks like "Personal budget" is the most popular, followed by "Family
monthly budget." (based on votes)
"nevinnh" <firstname.lastname@example.org> wrote in message
> Are there any household budget templates available in Excel?
Go to microsoft template site, on the sear...Symbols in Excel 2007 Chart
Hello. I would like to use the greek mu symbol in an Excel 2007
histogram. I am able to convert the "m" into the proper "mu" symbol
in the spreadsheet itself but this is not reflected in the resulting
graphic. I need for my X axis label to be represented by the proper
greek letter, not m. Does anyone know how to fix this issue?
Thank you in advance.
In many fonts, holding Alt while typing 0181 on the numeric keypad produces
�. This means you don't have to change the font for some of the characters
in a text element (and many tex...Excel 2000 tries to open unrecognizable file on startup
For the last couple of weeks, when I first open Excel I get a
Microsoft Excel Error pop-up window that says "This file is not in a
I am uncertain what file it is trying to open, but when I click "cancel" it
opens books1.xls. Which I usually ignore and go into "open file" and pick my
Any idea what is going on?
Thanks - Jeff
I suspect one of two things
1) Excel opens all files in it xlStart folder. Search for this and remove
anything without an .xls, xlt extension
2) If you go to Tools&g..."10th" on Excel
For the past few weeks, any time I enter the number "10",
the Excel program automatically adds "th" making it "10th".
This is also occuring on the Word program. I don't
remember making any changes to either toolbar- HELP!!!
I can think of one possibility, (and don't ask me how it may hav
happened), but look in Tools - Autocorrect and see if you can find "10
shown as being replaced by "10th". My program once started replacin
all lower case "p"s with upper case and I know it was nothing I did.
If that isn't the problem, I ca...Automatic backup in excel with copy to hard drive and to cd-rw
How do I get Excel to either automatically backup to hard drive and cd-rw, or
even when I hit save icon, go ahead and save to hard drive and cd-rw. I
already have auto save setup but backup file goes to same hard drive folder
as origianl copy. Kind of defeats the purpose of a system crash and wanting
a copy on removable media. Thanks for your help!
This Word macro auto-saves a copy to a floppy drive. You should be able to
edit it to save to the hard drive and CDRW, too. You'll also change some
stuff to make it an Excel macro:
*...combine multiple excel file in to one excel file and multiple worksheet
I am wanting to use the following code to combine worksheets from
multiple files. However I would like to be able to select folder which
contains files in a more automated way that having to change the code
every time, and also copy all worksheets with links and formulas
removed. Any help on this is greatly appreciated as I have limited
> Dim TargetWkbk As Workbook
> Dim mrgWkbk As Workbook
> Dim i As Long
> Dim Wks As Worksheet
> Dim fName As String
> Application.ScreenUpdating = False
> Set TargetWkbk ...New Workbook Path
Thought I would make a comment ...
Did you know there is no Path property for a New Workbook ??!!!
Of course the Path property is empty for a new workbook. What
would it be?
Microsoft MVP - Excel
Pearson Software Consulting, LLC
wrote in message
> Thought I would make a comment ...
> Did you know there is no Path property for a New Workbook ??!!!
Thank you for your...Why does Excel ask to save when no changes were made?
This does not pertain to a new document. I open an existing document just to
look at it, and when I go to close it, Excel asks if I want to save the
document. No changes were made, so it shouldn't have to be saved. It's
One explanation could be that there is a time formula in a cell that has
updated on openeing so the worksheet will have changed.
When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''''s razor (Abbrev)
&...My excel file is too large (5 mb) when it shouldn't be, why?
I have an excel file has ballooned in size for some reason. I have tried to
copy all the cells and then used "paste special" to paste just the values and
the file size doesn't reduce. I am copying numbers from an investment
website into my spreadsheet and there don't appear to be any issues with the
pasted cells but I suspect it is causing the file size expansion and very
slow performance. I then deleted all the cells around by spreadsheet and it
didn't help at all.
All suggestions as to how I can fix this problem appreciated.
If you do a Ctl-End, does...Excel & Word auto selection from menus
Ok, I'm a keyboarder, not a mouser. I use quick commands
like the letter code or arrows on menus to speed along
without the grab, aquire, click business.
Excel & Word seem to be periodically (not always)
automatically selecting menu items based on prior
selections if I use arrow selectors. How do I turn this
off? I get no help from "Help".
Please reply to my e-mail address:
email@example.com. Thanks! Would love to get rid
of this nuisance & keep speeding along.
...Cannot create new mailbox
I'm having an issue of not being able to create a new mailbox. I can
go through the process of creating the user in AD Users & Computers
and everything is successfull. I can even see the user in the GAL. But
I cannot access the mailbox by opening it nor does it show up in
system manager even after sending a message to the mailbox. I do have
full permissions to the mailbox. It seems like it is not being created
even though the recipient policy seems to be working because it does
generate an address for the account.
Any help would be appreciated.
...Creating Excel Invoice Template
I have been trying to customize a downloaded template but was frustrated so
trying to create my own invoice. My question is once I input the formulas
how do I keep/save them ???? when I enter the first calcualtions all is well,
but if I go back and edit in the cell where the formula resides I lose the
formula ??? I am a relative newbie to this so any help will be greatly
appreciated. I have searched this site and cannot find a link to creating an
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions wit...Sending Email in Excel
1.) I have a formula in a cell that when clicked, sends an email to
recipients in the formula. I have pasted the formula below. What I
want to do is put the date after the "End of Day: " part. However,
when you click on the link, it gives the serial representation of the
date if you use today(). Is there anyway to format so that is shows
the date formatted correctly?
In cell A1:
Person2@abc.com?Subject=End of Day - ",A34,": Acc: ",AB1," for
","$",AA1," | Feats: ",'Enh Feats'...New to exchange #3
Does anyone know how to take a large file break it down
to smaller parts send it through outlook and then merge
it back into one file within outlook on the other end.
Apparently there is a way to do thi within outlook.
There isn't anyway to do that with Outlook.
You could do it with WinRAR, or search for a program on google called
HJSplit. Winzip can create files like that too, but I prefer WinRAR.
MVP - Exchange
<firstname.lastname@example.org> wrote in messag...[ANN] New installer for 12.0.1
MacBu released a new installer for the Office 2008 Update 12.0.1 today. This
is not new Office bits to be installed, but the installer itself that was
changed. This change was a result of problems experienced by some Office
2008 users having a failed update to 12.0.1. If you are one of the
unfortunate few that had problems, this patch is for you. If you were able
to successfully update to 12.0.1 then you do not need this patch.
Continue reading for steps to properly update Office 2008 to version 12.0.1.
Diane, Microsoft Mac MVP (MVPs are not Microsoft Employees)
Entourage Help Page <...New check format
I modified a copy of current check report, and trying to use this new format
when I print a check. However, GP system didn't pick up the new format. What
should I do to make them recognize each other?
Thank you so much,
If you modified an existing check layout, you want to make sure to give
users access to the modified check via Advanced Security or Security,
depending on what your company uses.
If the reports.dic is local and more than one user needs to use the modified
check, you'll need to make sure each local reports.dic gets the modified
Hope thi...Excel 2000: Regional date problem
We'e just upgraded from Excel 97 to 2000 and are having
problems because dates in spreadsheets are showing in US
(mm/dd/yy) format rather than in European (dd/mm/yy). This
si true whether I use a standard date format or make a
I've checked the regional settings in Windows 2000, and
they are correct.
I thought Excel picked up the default from here. Any other
ideas where I might look?
Thanks in advance
I wasn't able to duplicate your problem, Alan. I switched to UK settings
through Regional Settings. Then I opened Excel 97 and entered =NOW() in two
ce...Copying decimal data to another column to integer 'on the fly'
I am working on Asset registers/Depreciation Schedules and at the star
of the year I need to convert over my previous years spreadsheets (fo
schools) to the new financial year. This means moving the accumulate
depreciation at the end of the previous year to being the 'openin
depreciation' for the new year.
I therefore want to copy a column of figures to another column an
paste to that column as values only BUT as INTEGERS.
I am running Excel 2003 - 'Paste Only' can solve the 'values' part bu
does not have conversion to an integer 'on the fly'.
...Excel countif and
is there a "and" condition if you use countif or sumif?
2 < countif(b1:b4,"=c")and(a1:a4,"=1")
"KEN" <KEN@discussions.microsoft.com> wrote in message
> is there a "and" condition if you use countif or sumif?
> 1 c
> 1 c
> 2 < countif(b1:b4,"=c")and(a1:a4,"=1")
...Percentage formula in Excel spreadsheet
Hi, In my spreadsheet cell E14 adds up E2 - E14 and cell C14 adds up C2 -
C14. In G14 I have put a formula to show the difference between E14 and C14
as a Percentage ( formula for G14 is =SUM(E14-C14)/ABS(E14) ). When the
Formula for G14 looks at E14 and C14 all it sees is a SUM formula to add up
the column. Does anyone know how to solve this problem. Many thanks for
Not sure I understand the problem; tell us what answer or error you ar
Also, don't you mean you are summing C2:C*13* in C14 and E2:E*13* i
Oh, and you can get rid of the Sum - this ...Excel macro error msg..
I get the following msgbox when I attempt to run a Macro - which is just a
simple text string to be put into a cell.
" 'xxx'.xls could not be found. Check the spelling of the file name, and
verify that the file location is correct.
If you are trying to open a file from your list of most recently used files
on the file menu, make sure that the file has not been renamed , moved or
'xxx.xls' trefers to a file name that was on my disk - but I deleted - I
can't find it after a search.
All macros when run, exhibit the same thing.....
Tried a goog...Excel #128
I have two excel workbooks I am working with. I am filling data from one
workbook (lets call it wkb1) by finding a country name, taking the
corresponding currency, and placing that data into an other workbook (wkb2).
The common fields in both wkbk's are the country name, but the prices are
missing in wkb2. Is there any way to quick fill the second wkbk by doing a
mass fill, or by creating a function that will search wkb2 with the name of
the country from wkb1, and fill in the corresponding data from wkb1? Does
this require a macro or visual basic?
Have a read on VL...Export Access pivot table to Excel
I am looking for a fix in below code, probably addition to it.
I'm trying to export a query from ACCESS 2003 to EXCEL 2003.
Default out put format of query is pivot table.
I want to export same to excel. I do that each time with the export
button which generates a temp file which I have to save all the time
by naming it.
So far I have managed to export only the data sheet.
I'm stuck with the pivot table portion.
These few lines I found while browsing and changed them w.r.t. my
Code is below:
Public Sub TransferReport()...open a new instance of excel for each file ? (Vista / Seven)
How under Vista & Win7 can we open a new instance of excel for each file ?
thx a lot people.