Store file sizes do not make sense.
I am running Exchange Enterprise 2003 sp1
My priv1.edb is 20GB's, my priv1.stm is 70GB's.
All but one of my users is using Outlook 2003. (the one user that doesn't
use ol2003 is me)
We only have limited use of OWA.
I have tried to perform an offline defrag, and the stm file only dropped by
I am left wondering what is actually in the STM file when you add up all the
mailboxes, it only totals approximately 18GB's.
The couple of questions I have.
What in the world of Microsoft is chewing up so much space?
Other than moving all of the mailboxes to another server, cleaning ...Cannot Create File When That File Already Exists Installation Error
I'm running a test install of MSCRM on a VPC and I'm getting an error
message that says
failed. Cannot create a file when that file already exists.
It gives me the option to Retry, which immediately fails and displays
the error again, and to Cancel, which will end the installation
process early and show me a log, but the log doesn't say what file it
is attempted to create that already exists.
The VPC is the latest one (not the one that's coming out right NOW,
but the last one). The server is running on S...Slow opening across a LAN
is it normal for there to be a significant difference in file opening times
1/ opening excel and then opening a server based workbook from within the
2/ going to the workbook on the server and double clicking
differential seems to be a magnitude of 5 or 10
We use xl2k at work and if you start the timing with the double click event or
clicking on the Open button, then I've never noticed a difference between the
As a test, can you copy a file to a local harddrive and try both ways with that?
(And a completely off the wall guess: Is the...Hiding formuals in cells question
Hi. I was wondering if there was a way to hide the formulas in cells without
protecting the sheet. I am making something for other teachers at my school
and I want to hide the formulas so they won't mess anything up on the
spreadsheet. Any help would be greatly appreciated. Thanks!
not without protecting the sheet but why is this a problem for you?
"JP" <JP@discussions.microsoft.com> schrieb im Newsbeitrag
> Hi. I was wondering if there was a way to hide the fo...File List Folder Outlook 2003
I found an article which describes how to setup a folder to view any file
system folder in Outlook 2002. I can't find any equivalent in Outlook 2003.
Basically I just want to have an Outlook 2003 folder named something like
"my files" and have its address pointing to a mapped drive. I have tried
setting up a "home page" location on a folder, but it only works for web
addresses, not file systems. Thanks in advance.
At the bottom of the Navigation pane, you should have buttons for Folder
List, Shortcuts, etc. Select the Folder List button.
Op...Hiding "0" values in pivot table
In a worksheet I have a listing of stock records with ItemNumber, Date,
StockLocation and NumberOnStock. When I make simple Pivot Table with
ItemNumber and StockLocation as rows and select a Sum of "NumberOnStock"
I would like to hide rows where the sum is "0". But this does not seem
to be possible.
Tried to follow the guidelines in the Microsoft article:
But no luck :-(
You could use conditional formatting on these cells - highlight the
cells,...How to permanently save the Outlook 2003 toolbar settings?
I just upgrtaded from OL 2000 to OL 2003.
I have a problem with the toolbars now:
When I start OL there are three toolbars visible, the Standard and
Advanced toolbars plus the "Norton Antispam Outlook Plugin" toolbar.
I have another antispam program and so I have disabled Norton in its
control panel, but the toolbar is still popping up in Outlook.
If I uncheck it in the rightclick menu it goes away but after I close
and then restart Outlook it is back again!
I have in vain tried to locate a "Save Settings" button in Outlook
2003 in order to permanently get rid of the toolb...Ill Ex03 server, can't open event log or change services with msc
I have an exchange 2003 server which did not come up happily after a reboot
which I forced after the latest IMF update. (Dell raid 5 powerdege Hardware
I have a message saying that " a service did not start" etc.
What I did was start in safe mode and try to change the service start up
manual, however althogh I could view the services, I could could not right
click and change properties. Also I could view the event log, but not the
properties for each event.
I was, however able to edit the registry to change service properities.
Reboot and go in in "un-safe&quo...Uploading Excel Files
Operating System: Mac OS X 10.5 (Leopard)
Any new Excel spreadsheet that I create opens and operates normally on my Mac. However, anytime it is uploaded - to attach to an email, to a syncing service such as Dropbox, to google docs, etc. - the file changes format and turns into something unrecognizable that cannot be opened with Excel. <br><br>Example: I just created a "test" blank spreadsheet and saved it as an xlsx. I emailed it to myself. Once attached to the email, it appears and opens as a plain text file. When I try this on...SYLK file format
I'm going crazy to find any updated info about the SYLK
(SYmbolic LinK) File format.
Google.com, Mamma.com, MSDN, TECHNET, I have searched
really everywere finding only useless things or broken
The only details I have found are older than 1990, and I
don't know how accurate.
Then, any help (links, info, files, anything) will be very
I need to know:
1) If SYLK is a standard and who owe it.
2) The actual (last) SYLK file format.
Many thanks in advance.
(you can reply here or to mario.red .n.o.s.p.a.m.
I have no idea if this is current...hide my name
When replying to an email or creating one from scratch how do i hide my name
in the "from" field...thx
fred <firstname.lastname@example.org> wrote:
> When replying to an email or creating one from scratch how do i hide
> my name in the "from" field...thx
Are you saying you want the reply to be anonymous?
Brian Tillman [MVP-Outlook]
no, I don't mind if my email is revealed.. just my name. I have tried by
removing it from the "User Name:" field in the email account but it
continues to show up. I have also removed from the header informati...Excel opens with no document -
Where is the default document for excel when it is launched? I am
looking for the normal.dot of the excel world.
Symptom: When I open an excel document it launches excel.exe to a blank
When I open a new Excel document and close it the document I opened is
maximized at that point. I was thinking about recreating or pointing to
the default excel document if it exists.
First try the usual tweaks.
Reboot your system.
Start Excel with Start - Run - type: excel /unregserver, then excel.exe
/regserver. It will start, put in all factory default registry settings,
then end. Now ...How sort filtered file.
I m facing new problem in these days. I have workbook which contains data
s.no. Name of Customer BillNo. Date Concession Form Form No. Amount
How can i sort data after filtering by customer name in ascending order with
serial no. I want to sort all data by ascending order of customer name.
Rao ratan Singh
As far as I know, if you sort it after filtering, you'll only sort the
filtered data, not the whole data set. If you want the whole data set
sorted, you'll need to do that before filtering.
"Rao Ratan Singh" <RaoRatanSing...Hiding and Un-Hiding Data fields
I am using a form for people to select data via dropdown menus and then
having it run through a query to filter results. Is there a way that I can
have certain feilds hidden until a toggle button or something of the like is
Basically I want have three choices of buttons: Year, Quarter, and Month.
What I ideally want to happen is when someone selects the button for year, a
hidden drop down menu appears where they can then choose from the available
years to filter through the query.
I would say I am above average with using access, but I have no idea how to
hide fields and then...How do I hide gaps in an Excel 2007 chart?
I have a bar chart that is showing gaps and i don't want them. The select
data > hidden and empty cell button does not give an option to hide gaps. I
think by default they are hidden but if you even click on this to see what it
does the gaps are shown and no way to turn off.
If you hide the actual rows then with the Plot visible cells only
setting on the gaps will be removed.
In xl2007 the setting is on the Select Data dialog, Hidden/empty cells
> I have a bar chart that is showing gaps and i don't want them. The s...Hiding a worksheet #3
I want to hide a worksheet. So, I went to the format menu and the "worksheet" option is grayed out. Why? And, how do I "ungray" it.
is your worksheet protected ?
> I want to hide a worksheet. So, I went to the format menu and the
> "worksheet" option is grayed out. Why? And, how do I "ungray" it.
I think Frank meant to ask about the Workbook--not the worksheet.
(Check under Tools|protection|Protect workbook or Unprotect workbook)
My question is: Is there another sheet in the w...Hide images when Hiding Rows
I have inserted images into cells, but when I hide the column the images
are not hidden with that column, they just get squished between the two
cells next to the hidden cell. Is there a setting or way to tie the
image to that cell so that it hides/unhides appropriately with the row?
kurt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35686
View this thread: http://www.excelforum.com/showthread.php?threadid=554712
You cannot insert an image into a cell.
You can overlay ...how to hide an ActiveX control?
i have an ActiveX control, written in C++, which has the
OLEMISC_INVISIBLEATRUNTIME flag set, yet when i display the web page
it is attached to, i get the familiar "red cross" graphic in the
middle of the screen - how can i hide the control so nothing is
displayed at all?
can u set the size of ur control as 1x1 pixels
"bhu Boue vidya" <email@example.com> wrote in message
> hi there
> i have an ActiveX control, written in C++, which has the
> OLEMISC_INVISIBLEATR...Problems With File Attachments.
I have an NT 4.0 workstation with Office 2000 installed.
Whenever I try and attach a file it tells me that I dont
have enough memory and to close some applications.
I do not have anything open.
Any help would be appreciated.
...Excel open files on task bar
I have a basic issue that I was thinking there may be a programming solution
For example: Lets say I have 5 excel files open. Then I want to change
files and I do not want to hit Ctrl+Tab and cycle through the files....that
gets too hard on my eyes. Then if I click on the Icon on the Task Bar it
does not identify the file that is active and I really do not like the Window
Menu Bar item because it has other stuff on it also.
Does anyone have a solution that is clean, clear and quick to show what
files are open and make selecting the desired file easier?
Also, why ...Report opens behind form
How do i make a report ontop of my form? I have a switchboard named "Panel"
from there i click "Runs Worksheet" and it opens behind the "Panel". Also, I
have a Report named "Single Rig Report" when I click on it, it opens ontop,
but when i X out of it my Panel is gone?? Im lost... Help!
Message posted via http://www.accessmonster.com
Use this to open a report in the preview mode.
DoCmd.OpenReport ,"rptYourReportName", acViewPreview
DoCmd.SelectObject acReport,"rptYourReportName", False
"stephendeloach via AccessMonste...Hiding plot Area
I have a formatted output sheet that has a Pie Chart
embedded. The data for the pie chart comes from a second
sheet using 2 ranges B2:B6 & D2:D6 B2:B6 is always
populated and contains labels. What I want to do is, when
D2:D6 contains 0 in each cell (or Null), suppress the Pie
chart but always show the Legend (which is driven by B2:B6)
All you see of the pie when all values are zero is a single line at the
first slice. The legend still appears. To hide the line, double click on
one of the wedges and on the Patterns tab, change the Border setting to
None. ...hiding rows
I have data in cells A7:DK394 which all have 0 in them until totals are added
in other worksheets which then pullthrough.
At the end of the week I have to Hide all rows from A7 to A394 that still
have 0 in them as no totals have been added in other sheets so the customer
has not posted with us.
is there any way excell can recognise the cells that have no data against
them and hide them automatically by pressing a button. or if they all start
off hidden unhide as data is entered.
Hopefully this makes sense
many thanks for any help with this as again its to save me lots of...Exchange Partition Full! Loads of Log Files
Came in this morning to find that email access has stopped.
Looking at the mail server I found that the d:\ partition on which the
exchange databases are stored had been flooded with "log?" files.
These are typically named E0003A5F.log.
There are 5,691 of these totalling 27.7Gb.
Exchange Server 2003 on Win2003 server.
Can anyone suggest what has happened here please?
> Hi all
> Came in this morning to find that email access has stopped.
> Looking at the mail server I found that the d:\ partition on which the
> exchange ...File w95inf32.dll
I have just installed Office Standard Edition upgrade on
my computer. I have not been able to use Outlook 97
because of an error. I had hoped upgrading would solve my
problem. When I try to load Outlook the message reads:
Error loading W95INF32.dll I can't get past this point.