Threads Replies Last Post 1369 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  >>   Worksheets Don't Properly Send When Emailing At first, when I tried to email worksheets directly from Excel, they sent just fine. Then, only a line or two would send. Now, nothing sends at all. (As in, recipients email me back asking where the data is.) My coworker is also having this problem. We don't mind simply attaching the spreadsheet via a new mail message, but emailing directly from Excel was convenient. What might be causin... 1 28.09.2006 16:16:01 Format Painter Question This is a follow-up to a previous question; How to turn off the "automatic" Format Painter. Since the Forum would not allow me to sign in or reply to the answer I received I had to come back in through the Excel Help Link and post another question to give my reply. I don't really care about how to use this stupid thing, or what key I have to press to make it go away, just like all of... 2 28.09.2006 16:12:12 consolidate data Hi, I have three workbooks that have identical structures or formats. I wanted to summary to data from them into another workbook. Ex: I would like to sum [Monder.xls] sheet1!C5 +[Teacher.xls] sheet1!C5+[Student.xls] sheet1!C5 into [Total.xls] sheet1!C5. Actuality, I would like to sum the value of C5 of Monder, Teacher and Student workbooks into Total workbook. I tried to use Co... 1 28.09.2006 16:12:01 Merged Cells in Worksheet, Test for XL 2003 Simple way to test for existence of any merged cells in worksheet. Must it be a cell by cell evaluation OR [Each myCell in myRange] is there a "merged state" that is reflected on a Sheet basis? [ i.e. like Activesheet.UsedRange.MergeCells] EagleOne... 3 28.09.2006 16:09:22 How do I stop sharing violation errors in Excel 2003 - file NOT sh Suddenly, EVERY spreadsheet I open and work on can NOT be saved without getting an error message "Your changes could not be saved to '{file name.xls}' because of a sharing violation. Try saving to a different file." If I do that, it saves to a file such a C867893 or something like that (letters and numbers vary). If I then try to Save As and use the old file name I get the message "Th... 2 28.09.2006 16:06:34 Macro prompt Hi, I have a macro that creates a new worksheet, deletes 2 tabs, then closes the worksheet. When I run the macro there are 2 prompts, 1-do you want to delete the sheets 2-do you want to save the worksheet. Is there a way to turn this off so the macro runs more smoothly? Thanks!... 3 28.09.2006 16:03:48 uppercase is there a way to convert all data in a range to uppercase and also make it so all future entries are in uppercase? ... 2 28.09.2006 15:59:02 An if question Hi I have in a row 3 different values that I want to compare with a specific value on the same row. It looks like below A B C D 10 20 30 22 If D is higher than B I want it to return B if is lower I want it to return A. So far so good, this I can do but if it looks like below and b & c are empty, I cant get it to return, A it just returna a blank. A B C ... 3 28.09.2006 15:53:02 Excel workbook is corrupted, workbook automatically saves on start Hi Guys, I have a group of users whos speadsheets seem to get corrupted quite often. The offending sheets cannot be opened in excel, it hangs at the start of opening the file,cpu goes upto 100% and just sits there almost like its in a loop. The file can be opened in excel viewer. I notice that the workbook also changes the modified date in explorer as soon as its opened? If I use any... 4 28.09.2006 15:51:28 Unable to read message I am having an unable to read file when I tried to upgrade a Excel template file from a Excel workbook in the local network. This template works when the source is on my documents files or on my desktop. Can you please help on this?... 1 28.09.2006 15:49:02 Password a Macro so certain users can press it I have a cell on my worksheet which is protected via the usual password protect worsheet thing. However, i want to allow one person to write in this cell my pressing a macro which allows him to do this, then lock again after if possible? Anyone any ideas? ... 3 28.09.2006 15:44:02 How do I turn off the automatic Format Painter? This stupid little "PaintBrush" keeps popping up and blocking the cells I am trying to work with. It is more annoying than the "automatic" mulitple copy clipboard because it actually sits on top of what I am working with, blocking it from my view. How do I turn it OFF??? Thanks... 3 28.09.2006 15:36:29 Shared File Doesn't Always Save There is a shared Excel file on the network that doesn't always save. Sometimes it does but other times (without warning) changes are not saved. Have tried using save, save as and the save icon. Same results with all - and never an error message. This is on a Thin Client Windows 2000 network, Office 2000.... 1 28.09.2006 15:12:01 Excel Macro Security Failing winXPsp2, Office2003 sp2. When opening excel spreadsheets via EXPLORER, if macros security is set to medium, when a second ss is opened it does not give the macro dialog. When the macros are run on the spreadsheet a warning indicating the security is to high, or a certificate is missing. (certificates are not used). If the same two ss are opened via Start->My Recent Documents. The mac... 1 28.09.2006 15:11:03 Dropdown from a Dropdown I am trying to create a dropdown menu that is dependent on another dropdown that I have already created. The simplest way I can think to illustrate this is to give the following example: Menu 1: User selects US State (50 Choices) Menu 2: Depending on user's choice in Menu 1, display a list of cities in selected state. (Multiple Choices)... 2 28.09.2006 15:00:01 Bulk change cells to Array Formula I have a sheet with several hundred cells which are filled with array forumlas. The problem is that none of the formulas have been entered by using CRTL-SHIFT-ENTER. Does anyone know of a VBA function which can be used to set all of these cells to Array forumlas? Thanks, Justin ... 2 28.09.2006 14:59:03 How do print only the used portion of an excel spreadsheet? Unless I request printing a specific number on pages only, my printer will print 1200 pages, even thought my file is only 5 pages long.... 2 28.09.2006 14:55:02 Formatting a formula within a cell I am trying to use a formula and text within the same cell but I want the value of the formula to have a currency format. Can this be done? I have even tried to use a separate sell to calculate the formula to give me a currency value and then input the value of the cell into the text/formula cell and that doesn't work. Example: I want the cell to read: $.50 per 3 ounces $.60 ... 5 28.09.2006 14:49:01 How do I sort data in tables alphabetically into a list Hi, I have some tables of data that contain items in locations in a tray storage system. I would like to be able to generate an alphabetical list of all of the items in my tables into a seperate worksheet. My tables are in the following format - a b c d e f g h i 1 item x item y item z etc 2 etc ... 1 28.09.2006 14:42:02 How do I turn off clipboard permanently? I am also having trouble turning off the clipboard. I have done exactly what the reply to the previous post suggests and I have do it repeatedly as it turns itself back on when I log off or restart the computer. How do I get it to stop turning itself back on?... 4 28.09.2006 14:37:53 Minimize the size of a file that contains multiple Pivot Tables I have an excel file with 4 tabs that each contain a Pivot Table using the same source data (another tab within the file). My file size is 32MB!!!! Is there a way to reduce the size of the file? Paul... 1 28.09.2006 14:14:02 Ctrl+C Issue I have the strangest thing happen that when I use the shortcut to copy it highlights and deletes cells B7:J24. Any one knows how to fix this issue? Using MS 2002... 5 28.09.2006 14:12:02 Macro to Split Window in Same Place Even If Columns Added or Hidde The following macro groups and formats a set of text boxes, splits the active window, and then freezes panes. The SplitColumn and SplitRow properties, however, seem to count only the VISIBLE rows and columns, but I need the window to always split along the top and left of the same named cell called “Window_Split_Cell” (with a range currently defined as cell D20). It needs to split at... 1 28.09.2006 14:06:02 Event: open workbook Hi, I want to run a macro when the workbook is opened. I am assuming that there is an "Open workbook" event and you can insert some code there. Does anyone know how to do this? I just want to go to a certain "tab"/worksheet? when the user opens the workbook. Thanks for your help!... 2 28.09.2006 13:58:09 Excel Hide/Unhide I hid 4 columns in excel and they saved the doc. The 4 columns are not showing. I would like to get the 4 hidden columns back. Please help!!... 3 28.09.2006 13:25:02 1369 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  >>