Search results for query: *

We are having what I consider a very odd problem. We have an Excel file that is updated each morning and emailed to a distribution list of 20 users. The file is emailed by an administrative assistant to the distribution list and is received and opened just fine by everyone on the list...except...

I just installed a new Abit VT7 motherboard and none of the on board usb ports are working. There are no usb ports/hubs showing up in my hardware list. I am running Win XP Pro sp2, so I would have thought the drivers would have loaded. Does anyone have any idea what the problem may be? Any...

I have a friend with a worksheet that has several columns containing formulas. They want to "transpose" the columns to rows, but of course the formulas don't work after doing a paste special-transpose, so they want to create absolute cell references in the formulas. There are A LOT of cells...

I'm hoping someone can help me with a VERY annoying situation that I have. I've search through all of the posts and found many references to "runtime error 91", but none in this context. When working in Excel 2002 (Win XP Pro), I receive this error when trying to navigate through a multiple...

I'm having problems with a particular file not wanting to re-calc. It's not a very large file (45 sheets), but it is very formula intensive. The file used to re-calc fine either manually or when set to automatic, but now it won't re-calc either way. If I save the file, close it, then reopen...

While I am "fairly" adept at using Excel, I'm reletively new to Access. I believe what I am trying to do shouldn't be too difficult, but I can't seem to figure out how to do it! I'm working with an Access database and I want to be able to set it up so that the user will be prompted to enter a...

Hi, Is it possible to assign keys, or "re-assign" keys in MS Office XP? I would like to either re-assign help to something other than F1 or even just disable F1. Thanks for any insight you provide. Steve

I've encountered a minor problem recently when starting Excel 97. After opening Excel but before the "blank" worksheet appears I recieve an error message. I believe it's just sort of an informational error (a window pops up with an exclamation point in a yellow triangle?) The window...

Hi, Hopefully this will be an easy question. I have a blank column in an Access table. I want to type "Trade A/P" in the first field and then copy it down the entire column. Is there an easy way to do this?? I tried doing it as I would in Excel....copy the field then highlight...

Hi, I'm hoping someone can help me with this. I have a large Access report grouped by vendor. It lists the Vendor name and address info then lists all dates and checks written to the vendor. I would like to break the pages so that a vendor won't be broken between pages (unless of course...

Hi, I have a rather unusual project (I think it is at least!) I have a 250 page Word document that has to be printed for a government office and they have very strict requirements for how the doc is printed. One thing they require is that the doc be printed with the page numbers on the back...

Hi all, I believe I already know the answer to this question, but I also know if I'm wrong, someone here will surely know it! When sorting in Excel, is there ANY way to sort on more than three columns?? Without doing multiple sorts on ranges? I have many huge spreadsheets which need to be...

Hi, I'm not sure if what I'm trying to do is possible, but if it is I KNOW someone here can help me out! I have an Excel add-in "Transfer Data From AS/400". When this add-in is installed it places a selection on the "Data" menu "Transfer Data From AS/400&quot...

Is there an easy way to sum multiple non-contiguous rows in Excel? For example +a1+a10+a20+a30+a40. Other than pressing +a1+a10+a20+a30 etc? Any help with this would be greatly appreciated!

I've created a custom toolbar to use with a particular Excel 97 file, and I would like to "attach" this toolbar to the file so it will appear when someone else opens the file. Is this possible? Thanks in advance for any help.

Hi, This isn't really much of a problem...just very irritating. A couple of weeks after installing XP Pro, I have begun to have problems with the task bar auto hide function. I have it set to use the auto hide, but after a while the task bar will no longer pop up. I have to minimize all open...

I have created an Excel file that I want to distribute to other people. This file also contains a custom menu (not toolbar)that I want to attach to the file when distributing it. I can figure out how to attach a toolbar, but not a menu. Can anyone possibly help me out with this? I'm using...

Hi, Can anyone tell me what the syntax would be for entering a series of key strokes into an excel macro. I know it can be done, but I can't remember how to enter it. In particular I am looking to put an "end up" and "end down" command. Thanks in advance for any help!

Does anyone know of a way to globally set a print range for multiple worksheets? I have several files that contain about 40 worksheets each. I can set many of the print items globally (margins, headers, etc)but Excel won't allow me to set a print range with multiple pages highlighted. Any...

I have a report that I create daily that requires naming several ranges. I am trying to figure out a macro that would automate the naming of the ranges, but so far I’m having NO luck at all! Obviously the area of these ranges changes daily...today range A is 4000 rows, tomorrow maybe 4250...