Threads Replies Last Post 38 Pages: <<  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38   How to avoid a copy of an unprotected archive? Hi, I have a worksheet I give for the students, but I don't want they modify. If I choose Tools -> Security -> Password to Modify, they cannot modify the original one, but Excel give them the option to save with another name and then make changes to this last one. How can I avoid they make an copy of an unprotected archive? TIA SantistaS ... 5 21.02.2006 15:11:37 at startup, i would like a specific workbook to open. i hav machine that uses excel to log die cast information. the machine will automatically have the attached computer start excel. i have a specific worksheet that i created i would like to have started, otherwise it is a 15 minute process to format the sheet to specific criteria. How how how do i do this? (it tried to use the "tools-options-general", but that just takes me to a specific... 2 21.02.2006 10:19:28 How can I eliminate the drawing toolbar when Excel2003 is opened? Excel 2003 always opens with the drawing toolbar displayed. I don't want the drawing toolbar displayed. I can manually remove it but next time I open Excel it is back. What can I do to have Excel open without the drawing toolbar?... 1 20.02.2006 21:30:29 Excel networking help needed for backup Im working on setting our database up for booking different business related things and have run into an issue with excel i have the network running and updating everything fine however i need to auto config a backup thats saved to a different directory that can only be accessed via admin to make it the master copy that cannot be tampered with while retaining the open excel network so ... 1 20.02.2006 21:11:32 How can i make formulas automatic (F9) Hi every time when i start excel i have to make formulas calculation automatic, all time it's come Manual I have to press F9. How can i make it automatic default. Thanks ... 2 20.02.2006 15:40:44 MY ATTACHEMENTS WON'T OPEN can't open my attachment it is an excel file type,excel spreadsheet file ,file extension is.xls, discription is a spreadsheet... 3 20.02.2006 15:39:41 Conditional Formatting from 3 to 5 Hi I need to set conditional formatting on 5 numbers to highlight any that match another set of 5 numgers that will change week on week (lottery numbers). I can set the conditional formatting to highlight any that match the first 3 numbers, but not the next two. Is there any way you can increase the conditions from 3 to 5? Thanks Cathy... 1 20.02.2006 10:16:29 Auto Fill Why won't the Auto Fill options button display when I drag the fill line?... 2 20.02.2006 00:28:15 Change Excel sheet order Excel 97. I'm cataloging my CD's - each CD details on one sheet, then I've renamed the sheet to the CD number) which is a 7 digit alpha/numeric format). I'd like to rearrange the sheets into alpha/numeric order. Is there any way to achieve this easily, please? -- KeithS. To reply directly, replace the first at with the second one... 2 19.02.2006 14:45:27 csv file opens in a single column I have several pc's here but only on one of them the csv opens in a single column. On the other pc's data is parsed into multiple columns. How can I get this done automaticly?... 5 18.02.2006 15:39:39 Can I use Excel to create a league table How can I create and update a league table for my local pool league using MS office or any other computer based method? I would just like to enter the weekly results into the computer and let it do the rest.... 2 18.02.2006 07:28:14 Can't make changes in Tools/Options in Excel 2003(2) I have recently installed Office 2003 Small Business Edition and am having a problem with Excel. When I go to to Tools/Options and try to change ANYTHING, I get the following error message: Cannot access directory 'C:\My Documents'. I cannot click on the various tabs or make any change on the tab that comes u p when I go to Options. All I get is the error message.... 1 18.02.2006 01:49:19 freezing panes I know that you can freeze panes vertically or horizontally, but can you do both at the same time? What I basically want is a sheet with 2 rows as as always visible header on the top, but also froze on the right so no matter how far someone scrolls to the right, the original screen still mostly shows. Thanks, Peter ... 3 17.02.2006 03:25:59 how do I protect formula's only, not entire sheet or book? In excel I created a very simple stat sheet for my staff to report their stats as well as show whether or not they are meeting standards for specific functions. On occasion the staff add a note to the sheet. If I protect the sheet they can't add any notes. I want to protect the formulas only so they can't edit or delete them accidently. Can this be done?... 3 16.02.2006 21:07:29 Excel customized tolbar We havea copy of Excel 97 that has some customized buttons on the standard toolbar. How can we move these into Excel 2000? We have two other machines that would benefit from these. Thanks in advance, Dan ... 5 16.02.2006 18:31:37 How do I get spreadsheets to open from my docs again I used to be able to open worksheets direct from a shortcut or through My Docs but now I have to open Excel program to open a worksheet. Can someone tell me how to get the option back as I have tried upgrading and reinstalling Excel but that didn't work. I have Small Business Edition 2003... 3 16.02.2006 01:22:27 Any utility for joining two or more Excel or CVS files Hi i am relatively new to Excel, but i was wondering if there was a utility, macro or whatever to join two or more Excel files (of exactly same structure). I am currently cutting and pasting them together, but it is oh, so tedious! ... 4 16.02.2006 01:14:37 are user-defined chart settings transferrable? Is there a way to transfer user-defined chart settings in Excel between users? Thanks, Ed Ireland... 1 15.02.2006 19:26:39 how to setup "To be continued"at each pg except the last one ? In Excel spreed sheet, how to make setup- of "To be continued: words at the bottom of each page except the very last one?... 2 15.02.2006 03:43:23 Changing Default paper size I can't find any information anywhere about how to change the default paper size in excel and publisher. I inherited 6 computers which have all been haphazardly thrown together and I'm gradually changing all the settings etc to a user friendly standard... I found instructions for Word, but Excel and Pub both still default to Letter... I don't have access to the install media or cod... 5 15.02.2006 00:35:28 lotus emulation I would like to be able to use the Lotus keystrokes, with which I am familiar, in Excel. I have selected Tools/Options/Transition to no avail! HELP... 2 14.02.2006 13:11:15 carriage return code I imported a list of contacts from outlook. Many of the imported street addresses have a carriage return followed by a PO box or suite number. I want to search the street address field and move the text to the left of the carraige return to another colum. Problem is, I don't know how to search for the carriage return. Can you help me? Thanks,... 2 14.02.2006 03:03:21 leading zero truncate - how to prevent ? When importing a .csv file where the data is encapulated (each item of data is enclosed in double quotes) excel strips off the leading zeros. Is there any way of preventing this from happening ? The issue particularly nasty in that it removes preceeding zeros from a zip-code, then the US postal service will not deliver. Any ideas ? ... 2 14.02.2006 02:02:03 Rows to repeat at bottom I know how to repeat rows at the top of a page, but how do I do the same with with rows at the bottom of the page? I have a multiple page spreadsheet each page should total the columns on the page. Also a second row of formulas will keep a running total of the current page amts and the previous page amts. Currently I do this by copying and pasting. ... 2 13.02.2006 21:05:38 I cannot load Excel from Office, a problem creating XLStart? I use Office 2000 professional. When I click on the Excel icon on my toolbar it goes into installation mode, then comes up with an error message saying could not create file XLstart. This happens when I go in from the pop up menu also. I rebooted and also inserted my disc and tried the repair option. Then I tried to uninstall Office 2000 but it created another error ther, I don't know ... 1 13.02.2006 20:41:14 38 Pages: <<  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38