Recent content by MikeRG2

Another thing you can do is go to the tools on the XP install disk and install the NetBEUI protocol on the machines in your little network. It can really help XP machines "talk" with older 95/98 machines without having to mess around with the "wizard". Just install on the machines involved and...

I have a series of worksheets in a workbook. Each sheet contains the hours worked and amount earned by each employee per paycode, per payroll. While the columns all remain the same and the sort is the same (last name, employee number), but the cell references do not remain the same. I would...

While I can see how to prevent a user from a local logon, does anyone know how to restrict the domains a user can log onto?

Thank you Geoff. When I move it onto the same worksheet, it will work fine, so you've got me on the right track. Later this week, when I get some time, I'll move the lookup table to another sheet and try to reference it from there, so it does not confuse the user who filling out the input sheet.

I saw that function, but do not see how to make it work in this case. How do I make G2 = value(F2) looked up in a table external to the spreadsheet. The example in help shows =VLOOKUP(1,A2:C10,2) Looks up 1 in column A, and returns the value from column B in the same row (2.17) How do I...

I have a table with old id numbers that I would like translated into new id numbers when input. For example old id number 1 is now 80550104. I would like for the user to be able to input the old id into a cell (in column old id) and have it check the table and fill the cell in column new id. So...

We are on a Novell network using Windows 2000 desktops. We have a department using Office 2000. When using Excel a problem occurs When the user opens an excel document and clicks on the FLOPPY DISK icon in the toolbar to save, then goes to print preview by clicking on the print preview icon...

You might want to run chkntfs (drive): at the command prompt to see if a "dirty bit" has been set that is triggering the autochk function. If this bit has been set by some other problem (like a recent installation) it will continue to trigger a check. You might want to run a full scan...

Here is an excellent source for information on Internet Explorer that might prove useful http://www.mvps.org/inetexplorer/

There are several Novell TIDs on this 1005533, 10017333, 2917432 all relating to how Excel (and Word) save files on a drive. I am working at a place which has had a similar problem. One of the fixes is to open Excel go to Tools>Options>General and uncheck the "ignore other...

If the problem is saving the Excel files, Excel 97 and Win2K Pro can have a simple conflict that can be solved by opening Excel, go to Tools, Options, and select the General Tab. Uncheck the "Ignore other applicaitons" box. This box is controls the DDE process to allow the Excel...

You might look at this Microsoft Q Doc. 1) Table Borders May Not Print Properly in Internet Explorer (Q257036): http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257036

You need to really identify your problem here. If it is hackers, the best way to deal with them is to keep them out of your system. Once in, a hacker can hijack your administrative account and do what they want using the admin permissions, no matter how you have locked down the other users. You...

We are using GroupWise 5.5 and have recently upgraded to Windows 2000 from Windows 95. Since then several users have experienced the random word replacement described in Novell TID 10052519. Replacing the WT61US.UWL file with one from a machine with a good copy fixes the problem, but does anyone...

If you go to the Window help and look at the information on incoming connections, it lays out specific steps you can take grant or deny users access rights. If your D drive is formated with NTFS you can create a group policy that will allow you to assign the file and folder permissions to...