| Thread | Last Post | Replies |
|
| excel worksheet "becomes" protected | 07 May 2005 09:03 GMT | 3 |
Using excel 2000 various worksheets become protected whilst editing them i.e. I use & edit for some time then all of a sudden I get locked out & told the cells are protected. When I go to "Unprotect" it's greyed out as only the "Protect" option is available.
|
| scrolling stops after I turn off autofilter | 07 May 2005 08:21 GMT | 1 |
I have a worksheet with approx 3000 rows by 10 columns of data. The file has been saved with the Autofilter on and one column filtered. When I open the file and either turn off the autofilter or simply select All in the filter that was filtered, the worksheet locks up and I can't ...
|
| Please help! I Can't close Excel! | 07 May 2005 08:21 GMT | 1 |
I deleted a few worksheets on my Excel then got error message "Formula is not valid". I tried to close the Excel, got message "Excel can't be closed." I didn't lock nor protect the worksheets. But at [Tools][Protection] nothing can't be highlighted.
|
| Workbook is linked to a file that was deleted. | 07 May 2005 08:21 GMT | 1 |
My workbook has a link to a file that was deleted. I try to remove the link but it says that the source is locked, but I can't find the source because it was deleted. When I try to copy it in a different way, it still copies the formula with the link. What can I do?
|
| Excel crashes when I Insert>CopiedRows | 07 May 2005 08:21 GMT | 1 |
Does any body know why Excel crashes when I Copy>Row then choose Insert>Copied Rows? This only happens on one sheet in my Estimate workbook and it's always the same sheet. And Excel doesn't always crash. I can copy rows and insert the copied rows without any problem on other ...
|
| Pls help- Dates | 07 May 2005 08:21 GMT | 1 |
Hi- since the english version id not working I am trying my luck here. Can someone pls help me. I have data in 2 columns and want to add the data in the 2nd column within a period ie within a certain date for
|
| Excel error "no more fonts" | 07 May 2005 08:21 GMT | 1 |
I have a workbook with ~30 sheets. I copied a few sheets from another workbook into it. My header and footer have now disappeared and when I want to print preview or view the header, an error message pops up: "No more new fonts allowed in this workbook". After pressing okay ...
|
| When I try to open a spreadsheet it hangs | 06 May 2005 12:12 GMT | 7 |
I work for Waste management in the IT dept. Several users cannot open this one particular spread sheet but can open others we're running 2000 Pro w/SP4 on all machines. I attempted to download Office SP3 and the system errored out, I removed all of the temp and still no success ...
|
| what is this error "Not enough system resources to display complet | 06 May 2005 01:30 GMT | 3 |
pls tell me, it's frustrating
|
| Excel numbers not sorting correctly | 05 May 2005 20:36 GMT | 1 |
I am aorting a spresdsheet with dates and names and want to sort it by a column of numbers. When I sort it gives me all 100+ numbers first then 1-99. I have tried a million times and cannto get ti to work correctly.
|
| run error 1004 - error when trying to build a pivot table thru an | 05 May 2005 17:12 GMT | 2 |
get run error 1004 - addfield error when trying to build a pivot table thru a macro. this macro worked fine under office 97. now that i have 2000, am getting this error.
|
| Lost a worksheet | 04 May 2005 12:10 GMT | 1 |
A faculty member at the university I work at has lost a very important Excel workbook and I don't know what happened. From what she said, she was entering data in her worksheet and somehow turned on the FilterKeys. She didn't realize that was on, so she kept typing.
|
| Repair MOD & INT Function in Excel 2003. Errors currently exist. | 04 May 2005 09:12 GMT | 1 |
The MOD function exibits an error. Start with 8 in A1 Increnet A2 to A32 by 0.1; (A2=A1+0.1) (A3=A2+0.1) Bx = INT(Ax); (B2 = INT(A2)) (B3 = INT(A3))
|
| Importing Excel files Microsoft Small Business Financial Manager | 04 May 2005 09:12 GMT | 1 |
I have several workbooks, not templates, in MS Excel 2000 that I have been trying to import into Microsoft Small Business Manager, but am thwarted at every turn. I am fervently hoping that I can learn how to use this application for my small business. I am aware that this ...
|
| How to print "scale to fit" & keep font size? | 04 May 2005 09:12 GMT | 1 |
When I print my large Excel spreadsheet to "scale to fit" one page wide, the print is so small I can barely read it. I still have plenty of space in the columns for a larger font. Why won't it print with a font that fills the column? I'm using Office XP.
|