I found the problem. I have an optional network and a trusted network. The optional network switch was plugged in to the trusted switch.
Thanks for all the help.
I haven't found the problem yet. I have been using a packet filter and it said that UDP is using about 35% of my network. That is more than TCP on my network. Here is some more information from the packet filter.
Destination Protocol Info
128.90.255.255 NBNS Name query NB...
I tried turning the MaintainServerList to No on 5 computers, but this computers are still broadcasting out. Some of the computers boadcast to 255.255.255.255 and some to 128.90.255.255 and some to 192.168.255.255. The 128.90.. is my trusted network and the 192.168.. is my optional network. The...
My firewall is showing my computers constantly broadcasting using ethier port 137 or 138. This just started doing this a few days ago. My antivirus doesn't show any viruses. I also have a switch, a printer, and two, "Snap Servers", NAS sending out the same broadcast. I used a packet sniffer to...
I am tring to run a query, which needs to filter a column by today's date. I have tried TODAY() and NOW(). I recieve a "syntax error in date" when I try this.
That was just an example. I am working with a template that the data changes every day. I have the worksheet filtered by a range of days.
Ex. #2
Filtered < 3/25/2004 and > 3/19/2004
a b c
apples .50 3/20/2004
oranges...
Subtotal will not do the same function as SUMIF.
ex. =SUMIF(A:A,A1,B:B)
a b
1 3 1.00
2 4 2.00
3 3 1.50
4 2 3.25
5 4 5.00
I just want to sum the 3's in column a. Column b has a filter that is equal to or is greater than 1.00.
I have a spreadsheet with auto filtering. I want to use the SUMIF function, but when I do, it sums the entire spreadsheet and not what I have filtered. Is there a way to do this?
When I try to save in Office XP it hangs up. When I click on "save in" to find where I want to save the file, it takes a minute or more to finally pull down where to save to.
How can you make a column identical to another column in a different worksheet, with the data able to change in one column and the other column change to be identical with the new data?
I am working on an Excel spreadsheet.
The spreadsheet has external data that refreshes every time it is open.
I have three worksheets in the spreadsheet.
I want a column to be the same on one sheet as it is the other.
I also have auto filtering on, so I want the column to change on one sheet...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.