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   Moving among protected sheets Hello all, It appears that I can not use the [Ctrl] + [PgUp/PgDn] to move from a protected sheet. Can anyone verify this? When I try the [Ctrl] + [PgUp/PgDn] key combo on a protected sheet, it acts like [Alt] + [PgUp/PgDn]: The worksheet scrolls left/right one page at a time. What if I do not have my sheet tabs showing? How do I move to other sheets (keyboard or mouse) when the sheet... 3 04.03.2006 01:58:39 Problem encountered Anyone know what can cause excel2000 to terminate when opening up a particular workbook. If I logoff WindowsXP and switch user the workbook opens up fine. This is very annoying. Pat ... 2 03.03.2006 15:01:02 How to show page breaks by default in Excel 2003 I set this option in Tools->Options->View Tab and check off the box in the Windows Options section of the tabe that says "page breaks", but every time I open a new workbook, it's off again! I tried to create a book.xlt file and place it in the C:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLSTART folder but that didn't work. I also tried placing a book.xlt in th... 1 03.03.2006 14:22:49 Wrong Settings Or Something Else. Help Pls. Hi everybody, I am a selfeducated VBA user and I have a lot of gaps in my knowledge. I spent 3 weeks doing a small program, (the program should help my mates at work), but as i expected it does not run on the PC at work. (No problems on my PC at all). I have Excell 2003, the one at work is 2000. I have used a calendar control, which is not available on the PC at work. I canceled all ... 2 03.03.2006 09:30:10 no sound sndvol32. exe missing where can i find it i have no sound from my speakers. it says go to add/remove and add . add what?... 1 03.03.2006 08:41:26 Drawing data from specific columns of a dynamic range Hi, I have historical data; 40 columns of vertically displayed data according to date which I use to create volatility and correlation matrices. I would like to look at the volatilities and correlations of the 40 contracts for different dates and different time periods. (For example, I would like to use data from 2/6/06 to 25 days past that date, or, I would like to use data from 12/28/05 ... 4 03.03.2006 06:53:48 Object In one of my worksheets, I used a Windows Media Player object and build some function with it. I put it on a shared folder and on other users computer I can't see the object, only a square there. I checked "Insert", "Object" and there is no Windows Media Player object in the list. My question is how can I import an object into Excel? Thank you very much in advance for any help! ... 1 03.03.2006 00:08:26 Template Wizard with Data Tracking Excel 2002 had an add-in (Template Wizard with Data Tracking) that doesn't seem to exist in Excel 2003. Does anyone know if there is a similar add-in for 2003? -- Rawblyn... 1 02.03.2006 15:28:02 number of userdefined formats is it posible to increse the number of formats? the limit is between 200-250 and that is a problem to me.... 1 02.03.2006 15:27:10 Copy using Macros I am designing a spreadsheet using macros in which I want to copy a range of cells from one sheet and paste to another. I am able to do that part but what I want to do is to find the way that the macro recognizes the first set of cells is already with data then should paste to the next one. I will appreciate any suggestion. -- JorgeAE... 2 02.03.2006 11:52:56 how to setup transferring data from row to column Can anyone help me here: How do I setup transfering data in a row to a column on another sheet so that when I input anything in the row, the column in the other sheet will be automatically filled. I tried =Sheet1!A1 and then copy down. But the second cell down becomes =Sheet1!A2, whereas I want it to be =Sheet1!B1 Thanks in advance!... 4 02.03.2006 10:14:19 How do I change the default font size on the comments balloons? How do I change the annoyingly small default font size on the comments. Tahoma 8 is way too small?... 2 02.03.2006 02:51:42 Formula Contains an invalid external reference to a worksheet Hello, I am trying to delete a link to a other worksheet. When I try to get read of the link it says “Your formula Contains an invalid external reference to a worksheet”. I have check MS Knowledge Base and none of the fixes their have worked. I check the worksheet that is being linked too and I could not find any invalid characters. Thanks Warren... 2 02.03.2006 02:46:43 restore xp excel menu tasks I opened an Excel workbook and somewhere in the background, it eliminated a menu item (Data) and many menu functions. I am unable to undo the damage as I cannot restore the menu and functions to the original settings.... 2 02.03.2006 01:20:29 How do I format a cell that isn't protected? HELP! I have a range of cells that cannot be formatted and they are not protected. What else can be wrong with them? How do I find out (I tried Ctrl `, but there was nothing in these cells)if there are hidden formulas or protection?... 5 01.03.2006 17:10:27 Default # of worksheets I am trying to set the default # of worksheets for a workbook. The setting in Tool > Options is totally ignored when I make the change in this dialog box. I have to modify the # of sheets in \XLStart\Book.xlt in order for it to work. Why does Tools > Options not work? What is the relationship b/w Tools > Options & Book.xlt - do the settings normally change the template. ... 2 01.03.2006 16:51:49 Column headings The nomal identifiacation on the column headings are ALPHABETIC. When i opened this particular workbook, the Columns are now NUMERIC. How can i change this back? Too hard to do formula. ... 2 01.03.2006 14:31:53 setting up default font size in comments how can i setup my comments to always appear with a 12 font size as default?? ... 2 01.03.2006 12:03:05 How to get separate Taskbar Buttons for each Excel Document? Hello, I am working on Windows 2000 Professional, with MS-Office 2000 installed. MS-Excel version is (9.0.6926 SP-3). Untill very recently, when I used to open multiple Excel documents, I used to get separate buttons in Taskbar for each of the open document. But now, i dont know why, (maybe because of something I installed or deleted), I only get one button in the taskbar for MS-Excel, irr... 3 01.03.2006 10:30:20 EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>YOU COULD BE EARNING OVER $3K A DAY , $100K A MONTH.INCOME. CHECK IT OUT. Investment is only $5. 99cents a month.</P> <P><A href="http://www.vosar.net">www.vosar.net</A></P> <P>Tel: 775-333-11... 1 01.03.2006 07:14:08 make a budget look like online banking w/ excel I am working on the budget for work, and would like to know if there is a way with excel to make it look like onlie banking. If not, something similar or if I could do something similar to what I want with Access. Basically I want to put in one program and just to be able to enter amounts without having to enter formulas everytime I use a different row and the same column. ... 1 01.03.2006 00:15:25 Does Office 2000 Excel support complex numbers at all? OK, so I re-installed Office 2000, and I selected every concievable option in the Analysis ToolPack and set them all to run off of my computer. After installing, I went into Add-Ons and checked every thing that could be checked. Yet, I still get "#NAME?' when try to enter the function =COMPLEX(1,2,i) The Excel help file seems to think this is legit, but Excel itself hasn't heard of it. ... 2 28.02.2006 22:22:35 Referencing other programme Hello, I have an excel spreadsheet and when it opens it is asking me whether or not to update info. I have searched using find "[" to try and find the externally referenced programme with no joy. Please can you advide me of any other way to track this down. Thanks in advance... 2 28.02.2006 22:06:34 Moving personal.xls Hello, Is there a way to change the location of the XLSTART folder? We have a process that backs up the "My Documents" folder, but XLSTART isn't in there, and I'd like my macro workbook included in the backup in case anything ever happens to my hard drive. I tried creating a new XLSTART folder in My Documents and entering the folder location in the Alternate Startup File Location on the g... 3 28.02.2006 17:53:51 Getting Excel MDI/SDI/Excel Instance to behave more logically I put this in a reply to a related post which may confuse people. It should be in it's own topic. I think I have figured out this stupid Excel thing. Excel has this bast%^%^ized MDI SDI thing. I think most people run Excel with it's child Window Maximized (which makes it really confusing). So when you click on another file it switches to that file, hides the other window but adds an... 1 27.02.2006 17:38:16 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