| Thread | Last Post | Replies |
|
| Unexpected File lock | 30 Dec 2004 08:33 GMT | 1 |
When opening a shared workbook, I receive the following message: "Unexpected file lock by {username}. You can override this lock or continue without doing so. If you continue without overriding this lock, you will not be able to save this file, but you can use File Save As to ...
|
| "Document is not completely saved" Warning | 30 Dec 2004 08:29 GMT | 1 |
I am getting a warning when I try to save a csv file in excel that states "Document is not completely saved". There is nothing in the help files about this warning; I've never seen it before in 15 years working with Excel. thanks in advance for any help.
|
| How do I deal with repeated document corruption in the same Excel. | 28 Dec 2004 08:40 GMT | 1 |
I have a relatively small and simple workbook that has now gone corrupted for the third time. It takes about 2 hours to replace all the formulae and formats that get stripped in the recovery function. This is intolerable!
|
| Too many fields in data form. | 27 Dec 2004 21:37 GMT | 2 |
I created new database in Excel and when I click Data, Form I get an error code that says I have too many fields in data form. I only have 13 columns, or fields! How many is too much?
|
| Excel will not let me group columns | 27 Dec 2004 13:57 GMT | 2 |
I have 84 columns of data (7 years) I use the group command to hide the monthly data. Excel will let me group 6 of the years and always leave one open. Excel responds with "Cannot Shift Object off Sheet."
|
| external file links in EMPTY workbook? | 26 Dec 2004 18:29 GMT | 1 |
I have a large project that involves reading data from multiple workbooks into a single source, then generating multiple workbooks filled with similar charts based on data from each original source. had good, clean chart template file set up. At some point a revision
|
| vlookup - error | 25 Dec 2004 01:07 GMT | 2 |
I can't find a solution to the following problem: I am using VLOOKUP to find a value relating to a product code. This is my formula. =VLOOKUP(A16,Sheet3!$A$6:$B$1690,2,FALSE)
|
| Columns in reverse order - how do I change back to "normal" settin | 25 Dec 2004 00:09 GMT | 2 |
I experience the odd situation that every time I open Excel, it gives me the columns in reverse order as well as changing position for the scroll bars etc. E.g. the row number indicator is on the right side. How do I change back to the original position, have not tried anything
|
| SUM incorrectly calculates when summing positive and negative vals | 24 Dec 2004 23:55 GMT | 2 |
Has anyone seen this problem? Enter these numbers in an Excel spreadsheet: 9980.00 2620.00
|
| multiple instances of Excel in taskbar | 24 Dec 2004 21:05 GMT | 1 |
The Windows taskbar no longer shows multiple open Excel (Office XP Pro) spreadsheets. Has anyone run into this problem before? If so, any solutions?
|
| Excel 2002 freezes with RTD links | 23 Dec 2004 11:45 GMT | 2 |
I had an RTD server built for me that brings large amounts of stock market data into Excel 2002 in real time. Every once in awhile, my computer will freeze (not just excel but my whole system) while running the
|
| SKU111.CAB | 23 Dec 2004 11:05 GMT | 1 |
I have Office 2003. Every time I try and open an Excel document it tries to reinstall Excel, and then crashes saying it cannot find the file SKU111.CAB. All other Office products work fine.
|
| when I click a cell in Excel adjacent cells also get selected and. | 23 Dec 2004 10:51 GMT | 1 |
Excel not working after installing windows xp sp2
|
| AN EXTRA WORKBOOK IS OPENING NAMED "PERSONAL" EVERY TIME I OPEN A. | 23 Dec 2004 07:41 GMT | 1 |
WHENVER I OPEN AN EXISTING EXCEL WORKBOOK, AN EXTRA WORKBOOK IS OPENING NAMED "PERSONAL". SO BASICALLY 2 WORKBOOKS ARE OPENING AT ONCE. WHEN I OPEN AN NEW WORKBOOK, IT IS AUTOMATICALLY TITLED "PERSONAL". HOW DO I STOP THIS FROM HAPPENING?
|
| Vlookup Syntax Error in Excel 2003 | 22 Dec 2004 22:23 GMT | 1 |
Please find a solution for the Vlookup Error the Syntax for Vlookup is VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) The Syntax that is showing in Excel 2003 on my spreadsheets is: VLOOKUP(lookup_value table_array col_index_num range_lookup)
|