Prohibited File Type?
If someone sends me a picture file as an attachment to an email message I
get shown "Prohibited File Type..file deactivated". I can see the pic in the
body of the message but can't open and view the picture file by clicking it?
Similarly if I try to attach a picture file to a message I send that also
same warning both before sending and to the recipient?
The files In question are jpg files.
Anyone advise please?
- do not allow attachments to be save or opened
- block images and other external content
Check (op....xls files opening in IE rather than xls
When opening files downloaded from the web, they are
opened in an IE windo rather than the appropriate Office
2003 tool (word, excel, etc.)
From a previous post:
There's a setting in Windows that you can change.
In win98, I can do this:
Start Windows Explorer
File Types Tab
scroll down to MS Excel Worksheet
click the edit button
There's an option to "browse in same window". Uncheck it.
That's where you can toggle the "confirm open after download", too.
How to Configure Internet Explorer to Open Office
Documents in the Appr...CRM 3.0 Reports:Error when trying to open reports on client m/c
I am unable to access CRM Reports from any other machine except the CRM
Server (Physical) box. I logged in as different users on the CRM server and
was able to open and see all of the reports based on roles. But I am not able
to view reports from any of the client machines. I am accessing Reports
through a web-client.
Upon trying to access reports through a client machine, I get the message "
error has occurred. For more information, contact your system
administrator". This does not tell me anything
I do not see anything unusual in the Web server (CRM Server), or the
Da...Hidden Folders and Files
I am using Windows XP pro, 2nd, service pack.
For some reason, I am now unable to see my hidden files and folders,
even though I was able to a short while ago. I don't know what I
have done to change this.
Under folder options I have selected "Display the contents of system
folders" and "Show hidden files and folders" However they are not
Any advise? Thanks.
> I am using Windows XP pro, 2nd, service pack.
> For some reason, I am now unable to see my hidden files and folders,
> even though I was able to a short ...Outlook Contacts Displaying Incorrectly
I synchronise contacts with Outlook and my mobile phone (Nokia 6230). When a
contact comes from the phone it displays as Smith, John in the Outlook list,
however when I open the contact and try to edit it says display as John
Smith. There must be another setting that is overriding this somewhere!
By default, Outlook 2003 displays contact names that are in your Contacts list in the FirstName, LastName format, as opposed to the LastName, FirstName format. In this situation, the first
name of a contact is used to sort your Contact lists because the Contacts lis...PERSONAL Workbook is not opening
WHen I open Excel, my PERSONAL workbook is not opening, then I can't access
to my Macros. I have checked if its located in the XLSTART folder and it is.
Can you help me to solve this out?
Maybe personal.xls was disabled...
xl2002+ has the abililty to quarantine what it thinks are bad workbooks.
They can keep track of them so that it doesn't even try to open them.
If you look under Help|About MS Excel, you'll see a button called: "Disabled
Check under there to see if it's marked not to open. You can enable it there,
If the workbook is real...How do I install when "file ZF561407.CAB can not be found"
...Excel 2000: File >> New menu command causes application crash
This is occurring on only one machine on a network!
After saving an emailed Excel template to a standard network location
for Microsoft templates, when selecting File >> New this installation
of Excel 2000 crashes ("Excel not responding" on Close program
dialog). On other machines there is no problem.
Have "repaired" Microsoft Office using that option from the
installation CD-ROM, have removed Excel from Office installation,
rebooted and reinstalled Excel. No change on the problem behaviour.
Everything else appears to be working just fine in this copy of Excel.
We ...Show userform at spreadsheet open
How do you make a userform open when you open a spreadsheet?
Can anyone help?
sheet or file?
Private Sub Worksheet_Activate()
lookup modal and modaless forms in vb help.
Private Sub Workbook_Open()
also see this site....
"Roger on Excel" wrote:
> How do you make a userform open when you open a spreadsheet?
> Can anyone help?
&g...What firewall ports to open to manage server through ESM?
Got 2 Exchange 2003 servers (in separate RGs) which are connected via WAN
and separated by Firewalls.
What are the Firewall ports I need to open in order to manage the remote
Exchange server, using a local ESM?
I don't know the answer, but why can't you use Remote Desktop Connection
(port 3389) for this? From my experience, it is at least 10x faster than
directly using ESM or ADUC and works great even over 56k dial-up to a VPN.
"Shel" <firstname.lastname@example.org> wrote in message
> H..."Do you want to save" when Excel OPENS
I understand about the "Do you want to save" message when you close
Excel, even if you didn't make any changes: Excel doesn't distinguish
between real changes and the recalculation of volatile functions.
But at work we've had a user claim that he gets the message when he
OPENS Excel when our add-in is checked (having been checked when
Excel was open before). Specifically, it asks "Do you want to save
changes to Sheet 2?" I'm sure it's not our add-in as such, since no
one has ever report this before. But it may be some interaction
between our add-...How to convert to absolute value?
How do I convert numbers to absolute value?
Edit - Copy.
Edit - PasteSpecial - Values - OK.
Or do you want a code solution ?
HTH. Best wishes Harald
"Betsy Marlow" <email@example.com> skrev i melding
> How do I convert numbers to absolute value?
On Thu, 24 Aug 2006 15:16:31 -0400, "Betsy Marlow" <firstname.lastname@example.org> wrote:
>How do I convert numbers to absolute value?
>...Don't plot zero values
I am currently using Excel XP. I have a scatter chart and would only like to
plot non zero values. These are not null values. Is there a chart setting I
can do to skip plotting zero values or do I need to somehow filter/sort the
data first and then plot?
Hey George -
If there are true zeros in the data, perhaps the easiest way to exclude them from
the chart is to use an autofilter on the data that hides the rows with zeros.
Alternatively, you could insert a column to hide the zeros. Say the range with zeros
is in B1:B10. Select C1:C10, and enter this formula into C1:
=IF...diable command button based on field value
I have a command button which I would like to disable based on the
If A = 1 then button is disabled
If B = 2 then button is enabled
Where you put the code depends on how the form works. If this needs to be
checked for each record, use the form current event:
If A = 1 Then
Me.Button.Enabled = False
ElseIf B = 2 Then
Me.Button.Enabled = True
But, what if A is not 1 and B is not 2?
Dave Hargis, Microsoft Access MVP
> I have a command button which I would like to disable based on the
>...Open windows explorer
Does anyone know how to have a cell "hyperlink" to windows explorer open to a particular folder?
Right-click the cell, select Hyperlink and point to your folder.
Message posted from http://www.ExcelForum.com
...Only 1 taskbar button when i open 2 excel documents
Hi all. When i open 2 excel documents i have only 1 taskbar button on the
taskbar even though i did not choose the option to group similar taskbar
buttons under taskbar properties. Hence when i want to switch between the 2
documents i need to go to window and select them. Hence how do i solve this
so that i can have 2 taskbar buttons of the excel documents on the taskbar?
Thks in advance.
Tools>Options>View, check Windows In taskbar
"inenewbl" <email@example.com> wrote in message
news:6F715432-2EB2-47AC-B737-56D63F37537A@mi...displaying negative values
how do I hide the display of negative numbers?
Regards from Brazil
> how do I hide the display of negative numbers?
That will work if cell A1 has a formula in it.
If negative numbers are just typed in, you can use conditional formatting.
Highlight the range of cells you want to format.
Go to Format > Conditional Formatting...
Enter cell value is less than 0.
Click the Format... button and select Color: and then click the white icon.
> =if(A1<0,"&qu...a larger window to view the files
When I click on the "FILE, OPEN" menu items I get a dialogue box showing a
list of all the Excel files on my directory and then I can chose the file I
want to open.
Often, before I select which file I want, I need to resize the columns
(Name, Size, type, modified) within that dialogue box to look at various
properties and it would be ever so useful if there existed a Macro or
utility that presented the list of files in a somewhat larger window so that
I did not need to move the column widths each time.
Needless to say, this does not just apply to Excel but that is a prog I ...Unable to import Quicken file to Money
I am trying to import my QUICKEN 2004 data file
(QDATA.QDF) into Money 2004. I followed all the
directions and validated the QDATA file first, but
NOTHING imports. All I get are messages that
indicate "Your Quicken file contained invalid transaction
types". The only transactions I have are account
(Checking and Savings) transactions - debits and credits.
I have tried this a number of times, and downloaded all
updates to Money, but nothing ever converts. Can anyone
You can not import Q2004 into M2004. You'll have to wait a few more days
and then import it into M2...outlook cant find file MSOE.DLL
when i try to open outlook an error msg comes up - cannot
locate file MSOE.DLL. when i went to start, find,
folder/files and searched for it i found it. how can i
fix the problem please help.
If you're using XP, it should be in the Documents and Settings\User Name\My
Documents\Outlook Express. This implies that it associates with the user
who's logged into the system. Are you logging in as User Name in the above
example? If not, that's why it can't find it. Further help is available in
MSOE.TXT in the same sub-directory.
<firstname.lastname@example.org> wrote...get a list of file in a directory
what would be the best way to return a list of files in a directory.
I know in VB you could use the dir function, but what should
i use in MFC.
Doen anyone know of a class available where I could say return all the file
in a certain directory and its sub directories
Take a look at the CFileFind MFC class.
Check Abdoul [VC++ MVP]
"Dylan Franklin" <email@example.com> wrote in message
> what would be the best way to return a list of files i...reminders without outlook being open
How can I get reminders and 'new email' indications without Outlook being
open? Ideally, when my computer starts up, I'd like whatever service is
necessary to accomplish this to start automatically.
Jesse Aufiero wrote:
> How can I get reminders and 'new email' indications without Outlook being
> open? Ideally, when my computer starts up, I'd like whatever service is
> necessary to accomplish this to start automatically.
You can't. The only way (and this only works for email) is to use a
third-party email check...Visio File Summary Dialog Box is showing wrong file name and size
I am using Visio 2003 ActiveX Control in my application using VB.NET
I am calling "visCmdFileSummaryInfoDlg" Command to open File Summary
Dialog Box. Dialog Box is open successfully but it always showing
Template file size instead of open file size in General Tab.
The information it shows is:
Type: Microsoft Visio Drawing
Size :(928 bytes)
Based on: Template - ValueStreamMap.vst
Can any one let me know about any property or way so that it shows
correct file size?
Can we assume that the new drawing has been saved to disk before you call
th...2 mirror files with :1 and :2
Not sure how, but have 1 excel file, lets call it FILEA.xls and when I open
it, it opens a FILEA:1 and a FILEA:2 workbook. Any change made to FILEA:1
gets repeated in FILEA:2 and vice versa. Looks like some sort of mirroring,
or changes being tracked, but track changes is turned off. Any help is
you've opened two windows of the same workbook (from the window /new window
menu) - just close one and then save - this should solve the problem
"DJR" <DJR@discussions.microsoft.com> wrote in message
news:F0F6BDF5-9DC2-486E-947C-ABBB6C4544...excel opens under task bar
I find that excel always opens under the taskbar.
is there some way to 'reset' the opening position to the screen
dimensions + taskbar size so it opens below ?
it seems to do this on XP pro and 98 SE from time to time.