Threads Replies Last Post 38 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Excel Upgrade Just got a new laptop, but it didn't come with Excel. I am running Micrsoft Windows XP Media Center Edition. My version of Microsoft Works is 8.5, which was installed with Microsoft Suite 2006. Saying that the version is 8.5 (this version was not specified as a requirement on the site), do I still qualify for the "Upgrade" version of Excel 2003? I'd hate to buy it and have it turn ou... 4 30.09.2006 19:40:33 excel versions I need to develop a MI report in excel. However, the version on my computer is version 2003, but persons who are going to look at it only have version 97. I've tried to create a test sheet on my computer and requested my user, who's got version 97, to open it. As expected, he was not able to open it. Is there anyway I can create the report in 2003 but the file is to be viewable in 97? -... 3 30.09.2006 13:15:38 How to access the error log? How do you access the error log when you get an error message saying: Excel.exe has generated errors and will be closed by windows. You need to restart the program. ... 2 29.09.2006 23:22:39 Startup Workbook I have preferred format for my start-up workbook. I have it saved in the book.xlt file the XLSTART folder. I recently changed machines. I save my book.xlt to the xlstart folder but I now get a different file when excel starts up. The book.xlt works fine when adding a new workbook, the only problem is the startup file. Any ideas? ... 5 29.09.2006 20:52:19 date formatting error My spreadsheet has several columns with dates entered. Just today the data is reading 38986 instead of 09/26/2006. I checked the formatting and it is set up right. Is there something else I can update so these dates appear correctly? THANK YOU TF... 2 29.09.2006 16:02:15 How can I use MS Word commands in an MS Excel toolbar? I use Excel primarily for its table--column format capabilities. The columns are typically filled with words, descriptive phrases, etc. I rarely, if ever, use Excel's mathematical calculation features. There are a number of applicable Word commands that I'd benefit from in Excel, but I can't seem to import them into the Excel toolbar. Can anyone suggest a plan of attack? -- thanks, ... 2 29.09.2006 12:48:54 find and replace When you choose "find" in excel 2003, you can change the option to search by row and look in value? Can you modify excel to have the default option to be to search by row and value?... 2 28.09.2006 13:30:15 unshare workbook I put together my first shared workbook. I want to do some formatting, but when I unshare the workbook I get the message that other users changes will not be saved even if I reshare the workbook. Does this mean that others can never enter data in the workbook again if it is reshared? I don't quite understand what this means. Help... 2 28.09.2006 13:29:00 how do I remove zone punches from numeric fields I have a customer who sends a proprietary file to me at Timex Corp. The data is from an old system. When loaded into excel, there is an alpha code or a special character in the low order units position of the fields. This indicates whether the amount is positive or negative. For instance, 0006688B is the value sent. The "B" is a numeric field with an over punch. How do I tell exc... 3 28.09.2006 09:10:02 How do I set up a labour purchase order in excell? ... 2 28.09.2006 02:19:53 put approx. 4 price list on i 1 piece paper with clip art I make wreaths etc. to sell I need to make list to put with the items when I sell them. Exp,price, I usually can put four on one sheet of paper with clip art on each one. I cut them when I finish.... 1 27.09.2006 09:19:01 both columns and rows are numeric.want the columns to be alpha in my excel sheet. the top of the columns are numeric as well as the rows. I want the columns to be alpha??? There could be some special format or sumation happening prior to getting the excel file.... 3 26.09.2006 20:16:02 How do I enable EMAIL in Excel and Office products!?! I'm running Office 2003 SP1 and I have the "send to" choice in the file menu but so far I've not found one other enduser here that has that menu choice. (we use Lotus Notes) Everyone is a mix of Office 2002 and 2003. I'm having a hard time finding info on setting it up. Can anyone help? Thanks in advance! ... 3 26.09.2006 14:44:58 how do i change tab highlight default color or contrast in 2003 The contrast on the sheet tabs in Excel 2003 is Minimal. I have tried changing my xp theme etc to no advantage. I remember in previous version the tabs would almost be a different shade. I work with groups sometime and this visual is important. Is there a setup function or default that can be altered. ... 3 26.09.2006 11:28:01 Excel Macros How can i setup a range macro were if the user dumps 10 cells worth of data it will select jsut those 10 cells however if the user dumps 20 cells it will adjust the range to select all 20 cells.?... 2 26.09.2006 09:06:11 Upgrading from Office 2003 Small Bus to Office 2003 Pro I recently upgraded to the Office 2003 Professional version from the Small Business edition. But the XML features of the Pro version do not appear to be available to me in Excel. In fact, in the "About Microsoft Excel" screen, it still appears to be using the Small Business Edition. Originally, before upgrading to the Small Business Edition, I had Microsoft Works, which should make me... 1 25.09.2006 17:07:01 Date Conditional Format I need a formula or code to apply into a cell that will flag a user if a record is greater than 90 days from today. I have tried variations of IF statements using the now function but have not been successful. Any assistance would be appreciated. ... 4 25.09.2006 14:17:01 how do you activate the right click drop down menu in Excel? I just got a new computer at work, and the right click menu doesn't work. How do I turn that feature on again?... 3 25.09.2006 01:11:15 Select All missing, Ctrl-A not working (Excel 2003 SP2) The Edit menu does not contain a Select All item. Using Ctrl-A does not Select All, if there is an area to select. For Example consider range (A1:A8) with data in each cell except for A3 and A6. A1 A2 A4 A5 A7 A8 Placing the cursor on A5 and typing Ctrl-A only selects cells A4 and A5. This is on each computer running Excel 2003 SP2 that I have tested. Is Microsoft gettin... 7 25.09.2006 00:54:30 Customized Toolbar Deployment for Excel 2002 Hi-All of my users need to use an in-house, customized toolbar in Excel. Is there a way I can mass deploy this toolbar, complete with button names, without having to configure it at each individual workstation. Also, is there a way I can import that same toolbar into Word? Thanks... 4 22.09.2006 13:56:31 permanently remove gridlines in regedit for Excel 2003 How do I permanently remove gridlines? I want to do this in regedit for Excel 2003. The current posts/replies do not seem to work as I do not have an Option3. Should I create a new dword? If so what should the value(s) be? Hex or decimal? Any assistance appreciated.... 4 22.09.2006 02:21:51 Use the Merge & Center Button with unprotected Cells - sheet prote In Office 2003 the Merge and Center button do not function when the sheet is protected while the unprotected cells do the same behavior, but if you move or cut merged cells and paste to another unprotected location the merged cells become unmerged and the target location becomes merged on an unprotected area. This behavior is good when you need to have part of the sheet protected and par... 2 21.09.2006 23:49:40 Startup and template locations in Citrix TS session and local session 'Morning all, Following a take-over I'm trying to work out how to make our Word and Excel 2003 add-ins and templates work properly both in an ordinary local session of Windows 2000 Pro (whether or not connected to the network) *and* in remote sessions via Citrix terminal services. Citrix is the new element (also it's change from a Windows to a Novell network). Until now, the setup h... 3 21.09.2006 21:42:50 HELP! Two excel windows I recently installed Hyperion Smartview and ever since then, every time I open an excel worksheet (whether or not it is linked to smartview) an extra worksheet (book1) opens! It isn't affecting excel at all, but it is quite irritating because everytime I save the sheet I am using and close it, it asks if I want to save book1. Any ideas as to how to prevent that extra window from opening??... 5 21.09.2006 20:06:01 How can I turn off the clipboard icon when cut and pasting? When I cut and paste a little clipboard icon follows the pasting throughout Excel. It constantly blinks and it's there in my way. How can I turn that stupid thing off? I know I'm pasting. I don't need it to remind me! LOL Thanks in advance. Caroilin... 2 21.09.2006 16:40:02 38 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>