Trouble with Filters on a large file
Have a huge file, 29000 rows with 6 columns.
Ran a auto-filter but the filter stops at the "1001" row.
Thought that I was quite familiar with auto-filters until this.
Can anyone please help tell me what's worng or what I should do??
Thanks in Advance
Think 1000 is the limit for items to display in the autofilter droplist
Try Debra Dalgleish's coverage on this at her page:
for a possible workaround
(Look under "Limits to Dropdown Lists")
GMT+8, 1� 22' N 103� 45' E
xd...Is it OK to filter *@*.jp, *@*.uk, *@*.ru
I am running exchange 2000 and want to block over seas addresses since we do
not get any legitamate emails from any emails that end with .jp, uk, or .ru
I am concerned if I add the filert using "*@*.jp", "*@*.uk", or "*@*.ru" that
emails that real emails might get blocked (IE if there was an email from
Would the "*@*.jp" filter block firstname.lastname@example.org?
On Thu, 19 Jan 2006 11:18:03 -0800, "Eric"
>I am running exchange 2000 and want to block over seas...macro for auto filter
I have a macro for a form button on a sheet. It runs an auto filter, and works fine until i protect the sheet. Then it will not work. Will auto filter not work on a protected sheet?... I have changed the security settings to allow auto filter in the protection tab.
You need to protect the sheet via code and enable AutoFilter.
The enable Autofilter will not stay when the workbook is closed
and reopened so you'll have to insure that the code runs whenever
the workbook opens.
Here's some sample code (modify to suit):
..Protect...Bug in Advanced filter
I think I have discovered a bug in the way Advanced Filter filters out
duplicates. When I perform this function and have the results pasted to
another location (or new worksheet) if the first 2 rows are duplicate they
are treated as not being duplicate. That is, it lists the first 2 rows in the
target location even though they are duplicate. It seems to work fine for
It is not a bug.
Excel treats the top value as a Title/list header unless you tell it not to.
So.......you get Cat as Title and Cat as first unique in the list below.
Gord Dibben MS Excel MVP
...Spam filter for accounts
I've configured my Windows Live Hotmail account to receive mails from other
POP3 accounts. These messages are saved into specific folders, e.g.
It looks like the spam filters of both Hotmail itself and of the Windows
Live Mail application don't check these folders, but they care only about the
"Inbox" folder. Is there a way to have a spam filter also for these
Did you turn on the SPAM filtering at the web access for those email
"John Skandar" <JohnSkandar@discussions.mi...Cannot connect to database after reformatting computer
I am using RMS 1.3 with MSDE Server. My customer's computer died, they had
not been backing up since Oct. 08. When they reloaded windows and I reloaded
Server, I can no longer access the old database. What can I do? Is the old
database recoverable? Does not see that database when I go to Administrator
in RMS. Thanks.
Are you able to locate the MDL and LDL files? If so you could try to attach
the database through SQL .and then backup the database and reinstall it
under RMS Store Operations Administrator.
> I am using RMS 1.3 with MSDE Server. My custom...In XP Home, intermittent drop in connection
First, if this in the wrong Forum or place, i apologize. I am a newbie with
I have 3 desktops running XP Home, hardwired to a Belkin N wireless router.
1 wireless laptop running Vista (that I hardly turn on).
I am able to see all PC's from all 3 Computers on the network. Laptop varies
at times so I can't say for sure about this.
I am having an intermittent drop in my internet connection every hour, every
day. The connection reestablishes itself without my help, but all connections
to the internet/server is lost making downloading and gaming frustrating.
Everything wo...Advanced Filter Case Sensitive
Hi, Is there any way to make an advanced filter case
sensitive? For example, I want to type DOG in the criteria
range and run the filter and only pull records that are
DOG, not dog. Thanks very much.
In the criteria area, leave the heading cell blank
In the cell below, enter a formula that refers to the first row of data.
Joseph S Johnson wrote:
> Hi, Is there any way to make an advanced filter case
> sensitive? For example, I want to type DOG in the criteria
> range and run the filter and only pull records that are
> DOG, not dog. ...connection status "suspended"
I am using SQL 2005.
Starting from today, when I do sp_who, every few minutes I see a new
connection to the database and the status is "suspended".
This new connection comes from the same VB.NET program that inserts data to
After a while, the program will get the error
"Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections were
in use and max pool size was reached."
What does the status "suspended" mean, and will it use up all the connection
f...Filter and sort
Suppose I filter a list and then sort the items of 1 column.Can I undo the
sort later .
Did you try it?
On Tue, 14 Jun 2005 21:51:22 +0300, "afdmello" <email@example.com> wrote:
>Suppose I filter a list and then sort the items of 1 column.Can I undo the
>sort later .
...how do i create an office data connection file
i want to call a parameterized data connection. i want to eventually put
this in office sharepoint server 2007's data connection library. every time
i open the connection file i have successfully created that connects to the
db, it want me to pick a table. i can cancel out of that and change it to
sql and say to use a procedure, but i can't save this file, and the "Edit
Query..." and "Parameters..." buttons are disabled so i can't set
why is it so hard to work with this thing?
...Access Denied when connecting to CRM 1.0
When accessing the MS CRM 1.0 Server I am always receiving the 401.3
error, access denied/unauthorised to access this resource etc... I am
a domain user on a computer connected to the domain (SBS2003 with CRM
running on a Win2K Server). IIS 5 is configured for Windows
Authentication only and the web page is prompting for a username and
password but failing for my domain user account however it succeeds
for the domain administrator account. I have an MSDN edition of CRM
and have licensed it successfully using the MSDN Subscriber
Organisation etc. I am registered in the CRM as a user with ...Connect to OWA very slow
We experience sending e-mail or open an e-mail message using OWA 5.5, the connection is very slow. Some time the mail couldn't send out even.
We are running Exchange server 5.5 under NT 4. It was installed under Dell Server PowerEdge 2300/500 with CPU of PIII500/100 with Hard disk space of 25GB and memory is 512/4. This server serves so many tasks: files sharing, printer sharing, e-mail sharing and antivirus. Will this cause the problem. If yes, if we are going to move exchange server to a separate server, can it fix the problem.
...How to detect whether the internet connection is broken
I use the Socket. I connect my client to a NNTP Server. I think the
connection will be broken by the Server if my client is idle for an unknown
period of time. The server closes the connection without sending any
acknowledgement. I have no idea on how to detect whether the connection is
broken or not. Can anyone have any idea? Thanks.
> I use the Socket. I connect my client to a NNTP Server. I think the
> connection will be broken by the Server if my client is idle for an unknown
> period of time. The server closes the connection without sending any
> acknowledgemen...connection to server interrupted only with wireless
I have Outlook 2003, alltel dsl, using a wrt54g ver 5 router setup as
pppoe. I can get wireless and wired to work fine accessing the
internet, but when i am wirelessly connected i get "Connection to
server interrupted" errors. The weird thing is I can setup an out of
alltel network email account such as firstname.lastname@example.org
and outlook works fine.
I have repaired outlook, created a new profile in outlook, deleted all
messages online, but yet it still doesn't work.
The router was replace once by linksys due to wireless issues so that
is taken care of.
Oh and befo...Couldnt connect to Active Directory
Im using exchange 2003 in win2003, our DC is in separate win2003 server. Am
experiencing problems connecting to active directory. When trying to open the
active directory users and computers snap-in from my exchange server, the
error is: Naming information cannot be located for the following reason:
The server is not operational. But I can manually connect to the domain
controller by right-clicking active directory users and computers-connect to
domain controller then manually writing the domain controllers name. I also
couldn't open the exchange system manager, the error messa...Exchange connection to DC
We just had an interesting problem, and wanted to see if anyone else has seen
this, or knows how to resolve it.
We have an Exchange 2000 server in a domain with 3 Domain Controllers (two
at one site, and one at another). We just were forced to reboot DC1 (the GC
for the domain) and the Exchange server stopped responding.
In DNS on Exchange we have all three DCs listed, but Exchange seemed to look
to JUST the one DC.
How can I set this up so that if any of the DCs are down, Exchange will
You can set up more than one GC in a domain...
vern...Advanced filtering #4
I have built a relativel simple spreadsheet that includes an advance
The Criteria range evaluates from a formula; specifically, it allow
the user to choose from a list of acceptable values (i.e.- a drop-dw
list), and the result is placed in a criteria field.
The Database Range is a list of 152 rows that get evaluated an
filtered. The problem I am having is that when I add additional row
to the Database Range, they do not get included in the filtere
results. I have no idea what is going on here, and I need help.
I have been careful to redefine the Database Range t...docmd.openform: Filter being ignored
I have a form which the user is able to select a customer, once
seletected a second form is presented which will enable the user to
update the customer contact details. The second form is to be
restricted to the required customer by using the filter parameter of
the docmd.openform command;
DoCmd.OpenForm "frmCustomer", acNormal, , """ID = " & Me!
[frmRenewalLettersByDate subform]!CustID & """", acFormEdit, acDialog
However, the filter is being ignored and regardless of which customer
is selected, another customers details a...flaw in Excel's filter command for negative numbers
When I filter to show all values less than a negative number, screwball
results happen. I can't believe this problem exists to this day.
Is there a workaround?
What is a screwball result? If some of the negative values are text they
won't be included
since text is always greater than any number
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.
"Easydoesit" <email@example.com> wrote in message
> When I filter to show all values less than a ne...Connecting to random ODBC source
I'm new to ODBC, and I'm trying to write this code that will be able
to read from an ODBC source, whose structure, basis, content and
everything are entirely unknown at design-time. Unfortunately, all the
sample code I've found (CATALOG and DYNABIND) seems to presume that
*something* is known about the source at design-time, such as the
table name, and some of the columns.
The problem that I'm really stuck on now, with the test data I'm
using, is when I try to open the recordset that is supposed to go
after the table data, "I get Restricted data type attribute viol...How to Filter .EXE, .PIF, .BAT, .SCR, etc. ?
Any recommendations on the best way to filter emails with
the extensions (.exe, .pif, .bat, .scr, etc.) on an
Exchange 5.5 server?
My AntiVirus software that runs on the Exchange Server
does not have this feature. Many of the 3rd party products
that I looked at only work for Exchange 2000 or higher.
we use MailMarshal for this purpose.
Have a look at http://www.netiq.com/products/mma/default.asp
Keep on fighting!
Please reply to this message, to let others know whether it was useful to
help you solve your problems or not.
Original Message:...Advanced Filter: No Filter
I can't get any advanced filter to work. For example, starting at A1 I have:
Joe Moe Hoe
Joe Moe Hoe
1 abc 21
2 12 22
Absolutely nothing happens with
Data > Filter >
Data range = a4:c6
Criteria range = a1:c4
It works fine for me when I change the criteria range to A1:C2, as expected I
Joe Moe Hoe
1 abc 21
when I filter in place, I don't know why you are using A1:C4 as criteria
maybe a simple typo?
"Evan Weiner - Richalnd WA" wrote:
> I can't get any advanced filter to work. For example, starti...Excel 2000: Lines hidden with filter
With a tabelle of daten.
After I have filtered my lines with a criterium, I
decide to hide those lines.
But when I go back on to my fiter to release the criterium,
I would like the filter to remember that I have hidden the
previous lines, so that they don t appear again. How can I do this?
do you mean that you want to filter the lines again?
"Simon" <Simon@discussions.microsoft.com> wrote in message
> With a tabelle of daten.
> After I have filtered my lines with a criterium, I
> de...Exchange 2003 Message filtering and 2rd party Anti Spam software A
Can you install Exchange 2003 Message Filtering on a Exchange 2003 server
already using a 3rd party ANTI Spam product like SpamKiller. SpamKiller uses
the Transport API, does anyone know if the MS IMF does as well? If so would
there be a conflict when both try to examine an Incoming email?
On Fri, 3 Dec 2004 10:25:03 -0800, "John Mac" <John
> Can you install Exchange 2003 Message Filtering on a Exchange 2003 server
>already using a 3rd party ANTI Spam product like SpamKiller. SpamKiller uses
>the Transport API, does anyo...