| Thread | Last Post | Replies |
|
| HELP: Need to recover damaged spreadsheet | 20 Dec 2004 10:46 GMT | 4 |
"Someone" has prepared a spreadsheet on a floppy (of all things!) and no backup anywhere. The XLS file on the floppy is corrupt, and Excel won't open it. Q1. Is there a recovery tool/option? Q2. I've been able to copy out the RAW data with Hex codes (07) separating the individual ...
|
| restrictions | 20 Dec 2004 09:45 GMT | 1 |
Is it possible to allow multiple users to input data into one spreadsheet/Excel file at the same time (shared file), and also restrict the information that the users can see and update. Such as lines 25-100 I would like one group to use and see, and lines 100-200 another group. I ...
|
| Saving Space | 20 Dec 2004 09:42 GMT | 3 |
I was wondering if using templates would help with eliminating the problem of "Too many different cell formats". The workbook is large and I have deleted the excess rows and columns from each worksheet, created more consistency between worksheets, and have deleted custom ...
|
| Link Rows From One Sheet To Another | 20 Dec 2004 07:36 GMT | 1 |
Was wondering if there was a more quick way to link rows in sheets. I have a XLS file with three sheets, sheet 1 being the master. I would like to highlight rows in sheet 1 and tell it to link to sheet 2 or 3 and add rows as need. Currently I have to highlight a row and then goto ...
|
| changing name order | 20 Dec 2004 02:09 GMT | 1 |
How do I change the name order in a mailing list so that the first name is first and the last name is last? Currently, cell contains last name first followed by a comma and the first name(s). Thanks,
|
| Address labels list | 20 Dec 2004 01:16 GMT | 6 |
Where do i start to look for making an address label list
|
| Averaging numbers | 20 Dec 2004 00:17 GMT | 5 |
I have a long colum of numbers,in row A. I would like to average every 4 numbers such as 1-4, 2-6, 3-7, 4-8 etc. and have the answer show in row B next to the last averaged number. Can someone help me..
|
| VB to create histogram | 19 Dec 2004 22:26 GMT | 2 |
I am trying to create a histogram using VB with data that I input and bin data records available. When I chose the macro recorder while creating the histogram, I only received the following line of code: Application.Run "ATPVBAEN.XLA!Histogram", , "", , False, False, False _ ...
|
| referencing cells with carriage returns | 19 Dec 2004 20:13 GMT | 1 |
I am trying to write a simple cell reference (=a62), in which a62 contains some carriage returns in it. CRs were originally entered as alt-return, and asc(CR)=10. In my new cell, I get the string of text showing the boxes to indicate the CR, but there is no CR realized at
|
| How To Copy Rows without Work Art | 19 Dec 2004 16:46 GMT | 3 |
I have some Word Art in say Rows 9-23, I use some Macro code to copy cells 9-23 down to 10 grouped rows below 23, but everytime I run the Macro it also copies a 'New' Work Art over the existing Art below Row 15. My fear is that my file size will balloon. My code simply states
|
| Excel Files Open Slow | 19 Dec 2004 16:33 GMT | 1 |
I used to use WinME with Office 2000. When I'd open an excel file it would be slow due to a request for a virus scan. There was a fix for this that in made a change to the registry. It was "regsvr32 /u c:\program files\norton antivirus\officeav.dll"
|
| How to change color for worksheet tab? | 19 Dec 2004 16:30 GMT | 6 |
I remember seeing this question posted before, but couldn't find it now. I have a workbook with a number of groups of worksheets. I would like to color code the tab name. How do I do it?
|
| Freezing Panes.. | 19 Dec 2004 14:13 GMT | 5 |
I want to freeze the top row, but when I select it and select window--> Freeze Panes, it freezes rows 1 thru 13 instead of just row 1. This is the second worksheet in my workbook, freeze row 1 works fine on sheet 1. Any ideas?
|
| FIX appears in Status Bar | 19 Dec 2004 13:27 GMT | 3 |
I'm temping in an office and found that on a computer that is shared with another person that one user's Excel program displays FIX in the Status Bar (lower right hand corner). When a number is entered into a cell on a new worksheet, the number is formated at a decimal. For ...
|
| various | 18 Dec 2004 22:39 GMT | 1 |
I would like to end a job with some humor. Is it possible to randomly show pictures or userforms when closing an userform?
|