File Size Limit??
Can anyone tell me if there is a limit to the file size
of an Excel 2000 document. We've got a guy here who has a
63Mb spreadsheet, and keeps wondering why he's
getting "Out of memory" messages every time he opens it.
I've put an extra 512Mb in his PC, but he's still getting
He's convinced that there are no limits to the size of
the file, but I'm pretty certain that there is...
The limit is memory.
"Jon" <email@example.com> ...Limits
I am doing a fairly easy programme on excel. It is a catchment runoff, and
evaporation calculator. But i would like to place a limit on a cell, and have
that exess go into another column, is this possible? EG 75 rainfall, soil can
hold only 10mm more. SO 10mm INFILTRATES, ie that cell should have a limit of
the max soil moisutre, the other 65mm RUNOFF's and thats a different column.
ANYBODY PLEASEEEEEEEEEE!!!! lol
You need a Workbook_Change event macro for that. The code you would write
in that macro should first check that the change occurred in a cell within
the range you want. ..."send as" permission issue
I am trying to assign a user1 the "send as" right to a certain mailbox.
In ADUC console I go into the properties of the user2's profile, under the
security tab I add user1 and check "send as" and "receive as" permissions and
OK out of everything. When user1 tries to send as user2 he gets this error
Your message did not reach some or all of the intended recipients.
Sent: 10/13/2006 12:09 PM
The following recipient(s) could not be reached:
(user's name) on 10/13/2006 12:10 PM
You do not have permission...Outlook 2007 Beta 2
I have a set of custom 'Outlook Today' Pages for MS (Office) Outlook.
Based on the old MSNBC "Outlook Today", they work very well with
Outlook 2003 installed.
With Outlook 2007 installed the 'default' page kind of 'stalls'.
The Pages work fine when opened in IE7 directly.
However in Outlook it begins to load and then just 'sits' with a blank page.
View Source SHOWS a blank page!!
"<HTML></HTML> " - in About_Blank.txt
Does GPFS seem like a solid product? I am thinking of recommending it to a
prospect and in the past I have not heard too many good things about GPFS so
I was hoping for some insight good or bad. I do have experiance with
Wenn/Soft so if you know how does GPFS compares to Wenn/Soft for FS or JC
that would be great.
...Help! IF function is too limited
I've created a drop-down list of cities in a cell, under which there
are two more cells to be filled out with the address and zip codes
corresponding to each of the cities. How can I do this, knowing that
the original list is a three-column list made of city-address-zip?
Ringo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27502
View this thread: http://www.excelforum.com/showthread.php?threadid=470178
Use VLOOKUP into the original; list using the DV value
=VLOOKUP(B...2008 R2 dpm 2007 setup: SIS-Limited not found?
I'm trying to run the command line to install the SIS component via
ocsetup.exe SIS-Limited /quiet /norestart
but it tells me it cant find this SIS-Limited component (on 2008 r2 x64)..
Any ideas what i need to do to get past this?
It turns out you just need to add the file services role in r2, dont need the
> I'm trying to run the command line to install the SIS component via
> ocsetup.exe SIS-Limited /quiet /norestart
> but it tells me it cant find this SIS-Limited component (on 2008 r2 x64)..
...Overwriting custom fields in MS Project 2007
If I create resource custom fields in a project plan, that is only relevant
to that specific project, how do I prevent the info from being overwritten -
for enterprise resources - when I publish the plan to the PWA & then reopen
Because of the way Microsoft has designed Project Server 2007, project
managers are not allowed to specify ANY information about enterprise
resources, even if you use a local Resource field to specify the
information. Therefore, there is nothing you can do to change this and
resolve your problem. Sorry. Hope this...Strange Formatting Issue
I'm stumped on a formatting issue here. Our environment is Exchange
One of my end-users is getting emails from a specific outside sender
that contains no body or text.
I asked this outside sender to send again and copy me.
Here's the strange part: In MY mailbox (Outlook2003) the body text
appears and it's listed as PLAIN TEXT. My end-user is getting the
email in her mailbox (OutlookXP) with no body text and it's listed as
I've confirmed with the sender...she's using Outlook2000 SP3.
Then I found out that the sender's IT departmen...ddd format to 'text' field
I have a column of data formatted as ddd for custom, Wed, for example. I
created another column to copy the data into, for charting purposes, and want
it to appear as 'Wed' in text format, not 6/13/2005 as it is in the other
column. Any suggestions?
> I have a column of data formatted as ddd for custom, Wed, for example. I
> created another column to copy the data into, for charting purposes, and want
> it to appear as 'Wed' in text format, not 6/13/2005 as it is in the other
> column. Any suggestions?
Da...Q: Rules limit
There is a limit for Exchange Rules on a 32K-size (KB147298)
Whether there is a way to change this limit for single users?
For me already three users have addressed with such requests :-
This is not a configurable limit. It's limited by the size of one RPC
"Kenin Alexander" <firstname.lastname@example.org> wrote in message
> There is a limit for Exchange Rules on a 32K-size (KB147298).
> Whether there is a way to change this limit for single users?
> For me already thre...Beginning Quantity in Inventory field
I'm sure this is a Richard Whaley question - where, other than in the
Inventory Turnover report is this field used? How are turns
calculated in this report?
MCP-GP, MCT, MVP
East Coast Dynamics
...Set One Field based On Another Field
I think I have a pretty simple request. I am looking for some script to put
on an on exit field. Here is what I need it to do:
When a value is put in say $550, if this is greater than a specified limit
in the code I need it to set Field2 to Yes.
So if field1 > 500 set field2 = yes
Real world example:
I have a dollar amount of credit to give to a customer, I want to auto
populate the approval required field with a yes.
Your help is appreciated.
Try: IIf([Field1]>500,[Field2]="Yes") However if the field is a Bit data
type then IIf([Field1]&...Pop3 issues #2
I am currently administoring a Windows 2000 Server running exchange. I
have downloaded and applied the latest service packs. Our email is
hosted by a third party. We use the Microsoft POP3 connector for
exchange to download all the emails using username and password. Our
problem is that we can't recieve any email. I can check the webmail
from the third party company. The email is coming in on that account. I
can see it "disapear" when our exchange server pops it. I can't see
anyting in the incoming folder on the exchange server. Its like it's
not even coming in. Any help ...Changing the name in the from field
I have set up a distribution list and would like to have just the name of my
orgination to show in the From field when items are sent out and not my
personal name and e-mail address.
Is there a way to do this?
Thanks Tom, but I do not see what your asking me to look for. I'm using
Outlook XP and when I look in the e-mail accounts (I think that's what your
asking me to do) I find no 'General tab', no 'Properties' for my mail
profile. So I'm still at a loss at what to do.
I do want to than you for your help.
"Tom - www.tditcorp.com" wr...Limiting Internet Email for Users
I want to stop users from sending Internet email from my Exchange 2000 server. I use it for a company wide mail server. Can anyone help me stop Internet Email.
This might help:
"Bob" <email@example.com> wrote in message
> I want to stop users from sending Internet email from my Exchange 2000
server. I use it for a company wide mail server. Can anyone help me stop...Text Form Fields
Not sure if I have posted this in the right area, but here goes. I am more
familiar with excel so working with forms in word is new to me. I have been
tasked with developing a number of forms at work in Word 2003 for posting on
our website. A guy who left, and is now not contactable, developed a whole
range of forms before he left. He made sure the forms could be filled in
online by inserting text editable fields for client use (both the 'greyed
out' section and dotted lines can be seen when viewing and completing online
and the dotted lines auto-delete as text is inserte...mapping and field length change
i created a custom entity added a custom attribute called 'test'
nvarchar(100) then published.
i then changed the length of the field to nvarchar(80) and published.
went into relationships -> created a new relationship (many to 1) with
Account, then when i tried to create a mapping i still see 'test' as being
i tried refreshing, restarting iis, restarting the server, republished
nothing seems to make a difference?
the strange thing is when i go into attributes and look at the 'test' field
i see it as nvarchar(80) so its changed it in the enti...Dropdown fields
How can I customize a dropdwn field, like "Industry" on the "leads" form?
Go to the Settings\Customization.
Find the lead object and open to edit.
Go to the Attributes, find the Industry and open to edit.
Modify the list
> How can I customize a dropdwn field, like "Industry" on the "leads"
...Perfomance issues while XML Transformation to an Excel using xslt
We have created a simple application that takes a dataset and
generates the data in Excel schema format. It uses an xslt file to do
the transformation for excel 2002 and so on. We are using the
dotnet.xml resource and not the MSXML 4.
The application is golden and works fine with realtively Medium size
of data(around 25MB). We started to see issues if the data is greater
then 25 MB where the transformation takes tooo long and sometimes it
just time out.
Any body having similar experience and their resolution are greatly
I also wanna know that if we switch to the syncronou...Calculation problem #N/A issue
Can someone tell me if the following is possible.
I am making a few basic calculations in a worksheet. Sometimes the
value returned is #N/A because a cell is blank. This is correct. Once
the cell is filled with a value the calculation is correct.
My question is: Is it possible to hide or show a blank or a user
defined value instead of #N/A?
Message posted from http://www.ExcelForum.com/
You can change your original formulas;
You can replace the "" with a 0 if you want.
"...Limit outgoing mail limit before send
Is there any method to avoid to send mail if the mail size is over a
If I set it in Exchange, the mail will first send to Exchange server and
check the size.
Any method to check the size before send to server?
I got this problem since the connection speed is slow, not like local
Exchange server and the client Outlook XP PC is far away, connect with a
64K line only.
How do you check/change the Exchange Server message
addressee(To, Cc)limit? When sending messages to servaral
recipients, some names are cut out. Thanks.
...Fitting lengths into a longer length
I have a number measurments that I need to get put in the most efficien
order to use the least amount of wood.
The wood can come in increments of 30cm such as 30cm, 60cm
90cm.....2.1m, 2.4m and so on. I need lots of little lengths (and som
longer) which on their own do not fit exactly with the 30cm increments.
I need to find the best fit within the lengths available to me.
Is anyone aware of anything I can do in Excel to put the small length
in the best order to fit within parameters given above?
This may seem complicated, due to my poor explaination
----------------------------...Swaping data from one field to another in Microsoft CRM
Is there tools available out there to swap data from one field in CRM to
e.g. data from Address_line1 need move to Address_line2 and data from
Address_line2 to Address_line1
I am not sure about a pre packaged utility to do what you require but once
when we were migrating data from ACT to MS CRM and we encountered a similar
issue where we had to swap between two fields. We wrote a utility to take
care of this kind of situation. A SQL script may also do the same job.
Do you want to do it regularily or are you just looking at one time swap?