| Thread | Last Post | Replies |
|
| MS Excel don't know file's password | 24 Mar 2005 12:15 GMT | 2 |
Hello. i'm trying to edit the a ms excel expense statement/re-imbursement template. unfortunately, it's password protected (and nobody at work knows what it is). does anyone know of a program that can crack an ms excel password or know a way of over coming this problem?
|
| Column Headings | 24 Mar 2005 10:15 GMT | 2 |
A colleague has Excel opening with the column headings as numbers instead of letters. Has anyone come across this before? How did it happen and how can we change it back?
|
| Autofilling data on a form | 24 Mar 2005 08:52 GMT | 1 |
I get myself into the darndest things. I have a requirement that calls for creating a form in Excel that automatically inserts dates which change by calendar quarter and state. The user would like to be able to make one entry and have the form autofill the correct dates ...
|
| Page view vs. Print View | 24 Mar 2005 08:43 GMT | 1 |
One of my co-workers has a workbook that has 1 page that is huge on the screen (2 screens wide) but prints normal - the problem I have is if I try to copy/paste the page in to a new workbook it formats out to about 8 pages. Any way to fix this?
|
| Formula help : adding | 24 Mar 2005 07:44 GMT | 3 |
I a new to excel and as a learning project I am makig a list of my movies. I would like a formula that would add up the cells with text in them. There are some blank cells as seperation for alphabetizing and I don't want to add those cells in my total. There aren't any numbers ...
|
| Opening old Publisher files | 24 Mar 2005 07:09 GMT | 1 |
I have many Publisher 97 files created on an old computer. When I purchased o new XP machine I loaded the same 97 Publisher program, but it will not open the files. I run a small business using this letterhead, etc. Suggestions?
|
| MS Excel expense sheet password lost | 24 Mar 2005 06:48 GMT | 1 |
Hello. i'm trying to edit the a ms excel expense statement/re-imbursement template. unfortunately, it's password protected (and nobody at work knows what it is). does anyone know of a program that can crack an ms excel password or know a way of over coming this problem?
|
| Cannot view visual basic functions | 24 Mar 2005 05:20 GMT | 3 |
I have had a spreadsheet emailed me which has some VB functions included. I need to look at this code but I see nothing in the VB editor. The spreadsheet seems to use these custom functions correctly. Is there some trick to saving spreadsheets such that the VB code can be
|
| How to stop save-as format warnings | 24 Mar 2005 02:39 GMT | 3 |
I don't use Excel to design the Sistine Chapel; I use it to keep simple lists and tables, one page per file. I don't want to save it in the newest whiz-bang document format every time my boss forces yet another "upgrade" on me; I want to save it in a backwards-compatible format
|
| highlight range if cell contains desired data | 24 Mar 2005 02:30 GMT | 7 |
If any cell in column D:D contains desired data in string format ( i.e. "Bill G" ), how would I highlight the data range in that respective row? Example: cell d4 contains the text "Bill G". Excel automatically colors the range
|
| How to put Time or Date Only in Cell 1) Time HHMMSS 2) Date YYYYMMDD | 24 Mar 2005 01:32 GMT | 1 |
I need to have a cell = the current time in the format HHMMSS And when I export as Comma Delimited or Fixed Length Ascii, I need for it to remain in that format. Ditto for Date as YYYYMMDD
|
| edit Excel spread sheet | 24 Mar 2005 01:05 GMT | 3 |
I am a very new user of Microsoft Office....seven years using Corel....my Daugher-in-law-to-be just sent me a spread sheet with guests names and addresses to edit. I was able to down load it after installing Excel but I can't edit it. Could some one give me detailed ...
|
| How do I allow a macro to run on a protecetd sheet without the user having to enter the password? | 24 Mar 2005 00:08 GMT | 2 |
I have a macro (see below) that begins by unprotecting the active worksheet, runs several subs, then protects the sheet again. The user runs the macro by clicking on a graphic in a locked cell. The sheet is normally password protected. I'm pretty sure that something odd has ...
|
| How to Copy Text to Fixed Length with leading Spaces ? | 24 Mar 2005 00:01 GMT | 6 |
I need to copy the text data in one cell to another cell and end up with Fixed Length Ascii. Example: A1 = XYZ
|
| Macro IF cells Contains ""; Then "" | 23 Mar 2005 22:23 GMT | 3 |
I was wondering of somebody was familiar with the possibility to start different macro's if the contents of a cell I refer to different then I want. For example: In most cases the Cell A38 on sheet "Quote" contains "General", if so I want to activate macro "Sub ...
|