| Thread | Last Post | Replies |
|
| Excel 2007 Files grow larger and larger | 23 Apr 2007 07:27 GMT | 1 |
I have several spreadsheets that for some reason are growing to over 200 megs in size and this is in the new excel 2007 format. The spreadsheet is only 53 by 70 columns and shoud be only about 200 k. What I found is that for some reason is adding data for the full length of
|
| Creating Files in a Path that contains [] | 22 Apr 2007 08:52 GMT | 1 |
When I try to save an Excel spreadsheet for the first time in a path that contains the characters '[' or ']' I receive an error that these characters cannot be in the path. However, if I try to save a file that already exists there it saves fine.
|
| How do I format Excel 2007 to accept dates in the 1800's? | 22 Apr 2007 08:43 GMT | 1 |
I am using data in Excel 2007 from Access 2007 but Excel does not recognize dates in the 1800's. Any resolution to this error? Marian
|
| Why when I sum a column it always reads zero? | 21 Apr 2007 22:00 GMT | 1 |
I have a spreadsheet and am trying to balance the columns. When I sum the totals of each column horizantally the result is always zero. it has worked ok on all the other worksheets but not this one and I don't know what I have done.
|
| Excel 2007 Hangs | 18 Apr 2007 19:02 GMT | 2 |
For three straight days MS technical support people has tried to get my just-installed copy of Excel 2007 to work. Still no success so far. I successfully installed Excel on my laptop, but the Excel installed to the desktop invariably crashes after a few clicks, whether the
|
| Blue Screen Crash when opening an Excel file | 18 Apr 2007 18:40 GMT | 3 |
I have Excel 2003 installed on a Win XP SP2 PC and sometimes Windows will blue screen when you click on an Excel file to open it. The PC is patched with the latest Windows security updates, and the PC is a fairly new machine, a Gateway E-4500S desktop model. It seems that this ...
|
| Cannot open a workbook in excel2007 - file works in excel2003 and | 18 Apr 2007 00:37 GMT | 1 |
file also opens with excel2003 viewer. As I cannot open the file I cannot use compatability checker. File is not shared. File is about 5MBytes with about 14 worksheets. Contains conditional formatting but no links to other files. What happens is excel stops responding ( I have ...
|
| MSOSB 2000 Asks for Installation Disk | 17 Apr 2007 22:36 GMT | 1 |
I was able to open Excel until today. Now each time I try to open Excel in MS Office Small Business, a window pops up and states that it is installing, then asks for the disk. Any idea why this is happening?
|
| Strange calculation issues | 17 Apr 2007 18:52 GMT | 1 |
Occasionally my coworkers and I encounter an issue where after making a change to fairly large spreadsheets, we'll do a recalc (CTRL+ALT+F9 calc) and nothing will recalc. We frequently have to do a Find and Replace "=" with "=" in order to get the calculations to update.
|
| nested if with and and or functions | 17 Apr 2007 13:20 GMT | 1 |
I have to make a formula using a nested if function to determine the # of vacation days ea. employee is eligible for based on the employye's job status in column B and on the #of years employeed in column C. 17days for FT who have worked more than5 years,12days for FT who worked ...
|
| How to kill the Excel object from windows task manager? | 17 Apr 2007 07:42 GMT | 1 |
I am not able to remove the excel object from windows task manager.Though I used (.Quit) and (.Closed) method still it is not working. Kindly plz help me and provied me the code for the same. Hopw to get a positive response.
|
| No colours on excel sheets | 16 Apr 2007 10:32 GMT | 1 |
Excel 2003 No colours show up if i select a colour for figures, letters, frames etc. When printing all colours appear correctly. Which button I pressed by mistake?
|
| Range naming problems | 16 Apr 2007 08:22 GMT | 3 |
This post is a continuation from a related post under Access data base reports, titled: Using OLE frame with an Excel sheet for a report template After copying a sheet by copy sheet to a new sheet name. Excel also copys the range name defined on that sheet. It creates a mutiple ...
|
| How do I cancel an XLQUERY? | 16 Apr 2007 07:24 GMT | 2 |
I am trying to open a file that was created by another user no longer with the company. When I open the file I get the following message: "Cannot find XLQuery.XLA!Register.DClick, which has been assigned to run each time "[file name]worksheet name with in the file" is opened.
|
| Application Error | 15 Apr 2007 13:32 GMT | 1 |
Hi every one, I am getting the following error when i am trying to run the ms-query application "msqry32.exe Application Error
|