|
Excel print error [no printer installed] - when printers are insta
Essentially the same issue as Nutrino posted on 9/7/08 - with no solution
offered. Excel 2002 running on Vista Ultimate 64 PC cannot find any of the 3
installed printers; even though all other Office XP Pro applications have no
problems using these printers. Excel was fine until last night, but now
cannot "find" any printers.
The EULA notice now appears every time I start Excel [and w...
|
2 |
12/18/2008 3:22:00 AM |
|
|
Excel 2007 crashes when converting to XLS
I have a large file (140 megs) of unrelated pairs of data and charts. I want
to convert it to .XLS. When I try to do so, Excel crashes. I tried to cut
the file in half, thinking that the size would be the problem. It still
crashed. I then created a dummy .XLS file and moved about half to the dummy
..xls file. When I saved it, Excel crashed again.
...
|
1 |
12/18/2008 2:42:01 AM |
|
|
Formatting lost when excel 2003 .xls file is saved in excel 2007
I am facing a strange issue with some of my clients using excel 2003 files in
excel 2007. When the file is saved as .xls/.xlsm format in excel 2007 and
re-opened again, all the formatting of date and number fields as well as the
color of the cells is lost. When i try to do the same on my machine, the
original format is retained.
Any views on this issue is appreciated. ...
|
1 |
12/17/2008 6:29:02 PM |
|
|
Values Change in Cells
A user has noticed an oddity in Excel 2003 and now Excel 2007: It
spontaneously changes certain values.
For example: 2685.98 sometimes changes to 2621.98 (a difference of 64) and
1915.45 sometimes changes to 1883.45 (a difference of 32). It may be doing
this to other numbers; the user has only noticed these two. It happens in
all spread sheets.
Sometimes you see the "correct" value (2...
|
1 |
12/17/2008 6:16:01 PM |
|
|
Excel 2007 crash on exit
Every time I exit Excel 2007 I get a message saying Excel has had a problem
and needs to close after which it restarts the program.
Otherwise the program seems to run and funtion normally.
I'm running Vista, with all updates, office has all the patches I know of,
and I've run the office diagnostic with no problems found.
Any suggestions appreciated....
|
4 |
12/17/2008 3:49:42 PM |
|
|
XL 2007 SP1 - MonthView control problem
I have built a spreadsheet that works fine on 2 machines, using the
"Monthview 6.0 (SP4)" control as a date picker.
However, when I try to run the spreadsheet on a third machine that is
supposed to be built the same as the other two, the Monthview control shows
as a big red X.
So, I checked the mscomct2.ocx control was present on the third machine. It
was exactly the same as the firs...
|
1 |
12/17/2008 11:01:28 AM |
|
|
GLDI9097.xla
In Excel 2007, I am receiving an error message when I open excel files:
"R:\....\GLDI9097.xla cannot be found. Check your spelling or try a
different path"
It is the full path of where the file is saved. Does anyone know what this
file is for or where it s/b stored?
...
|
2 |
12/17/2008 7:15:10 AM |
|
|
ODBC Microsft Access Driver Error-Too many client tasks
I am linking information from an Access database through new link ODBC Access
Database. I have received the following message [Microsoft][ODBC Microsoft
Access Driver] Too many client tasks.
Am I limited to how many links I can put into a spreadsheet. At this point
I am on page 1 of 4 that is needed?
--
Teresa
Norfolk Southern
Roanoke VA...
|
2 |
12/17/2008 7:14:59 AM |
|
|
Undo and other issues
Recently, the "undo" function (CTRL-Z, and edit menu) have stopped working,
and I'm seeing other commands in the edit menu (Can't close, etc.).
The other issue is that pop-up menus & command boxes (such as "customize"
and "options" from the Tools menu) have no background color. Changing the
color pallette using the "display" function in settings does not fix the
problem.
I'm using ...
|
2 |
12/17/2008 7:14:58 AM |
|
|
Linking Access to Excel Spreadsheet
I am linking information from an Access database through new link ODBC Access
Database. I have received the following message [Microsoft][ODBC Microsoft
Access Driver] Too many client tasks.
Am I limited to how many links I can put into a spreadsheet. At this point
I am on page 1 of 4 that is needed?
--
Teresa
Norfolk Southern
Roanoke VA...
|
2 |
12/17/2008 7:14:57 AM |
|
|
application initialization error
I am receiving the following error message: Application Initilaztion error:
preference set "PrefSet 1" defined without path attribute.
How do I correct?
Thanks...
|
2 |
12/17/2008 7:14:56 AM |
|
|
Pie chart bug
I've done a search, and I don't think this has been addressed anywhere.
Forgive me if I've missed something.
Zero values at specific positions in a data table cause issues with pie
charts in Excel 2007.
In a new spreadsheet, enter the following data...
Thing1 5
Thing2 8
Thing3 6
Thing4 9
Thing5 0
Thing6 6
Thing7 8
Select these cells, insert a pie cha...
|
1 |
12/16/2008 9:14:04 PM |
|
|
quotation mark in formula seems to crash excel!!!
I have a user who is convinced that everytime she enters a quotation mark (")
in her formula, the application crashes and has to restart. Please see below
Below is description of formula that caused Excel to close.
this formula works:
=if(and(f3>=j3,f3<=l3),"Lower",if(and(f3>=m3,f3<=o3),"Middle",if(and(f3>=p3,f3<=r3),"Upper",f3>r3,"Above Upper","?"))))
if try to ...
|
1 |
12/16/2008 8:11:02 PM |
|
|
Format in cell when insert data
Good Morning
I have a problem when try to insert data on sheet workbook, because when
trying to log information generated through a dts from sql server sometimes
loses the format of the cells and generates error...
|
1 |
12/16/2008 4:53:01 PM |
|
|
cannot empty the clipboard message - how to stop this message
When I am copying and pasting I sometimes get this message which pops up each
time I copy. It allows me to continue, but it is annoying. Why does it
happen? How can I stop it? The clipboard is empty when this happens....
|
1 |
12/16/2008 2:35:01 PM |
|
|
vlookup error
Sometimes when using the vlookup function I get the following error:
Invalid reference. This file version cannot contain formulas that reference
cells beyond a worksheet size of 256 columns (column IW or higher) or 65536
rows.
I'm not really up on computer language, so it's preferred if your reply
could be for the layman.
OS is Windows XP w/SP 3
Excel verision is MS Office 2007
An...
|
2 |
12/16/2008 11:27:03 AM |
|
|
URGENT! OLAP Cube reading from .tmp file
Hi, I'm really hoping someone can help me with my issue!
I have a data cube reading from MS Access, and a pivot table reading from
the data cube.
Excel won't let me update the pivot as I get an error message saying the
cube file cannot be opened for writing and is showing the file being linked
to the .tmp file.
I have no idea where this file is, as someone else has created the cube....
|
1 |
12/15/2008 10:25:01 PM |
|
|
Excel 2007 loses data when minimized
We have several users who routinely minimize spreadsheets while working on
other things, but when they go to maximize the spreadsheet, most, if not all,
of the data is lost - the spreadsheet appears empty except for random cell
outlines scattered about. This does not happen every time, but certainly the
majority of the time.
--
Vee...
|
1 |
12/15/2008 10:15:02 PM |
|
|
Excel external connection problems
I have a spreadsheet with data that I query a web site for. I usually
refresh the data daily by right clicking and selecting "refresh data". This
has worked fine for months, but now all of a sudden it is not refreshing. I
clicked on the data tab and selected "edit query" and at the bottom of that
box it says "detecting proxy settings" and just sits there without loading
the page. T...
|
1 |
12/14/2008 7:33:00 AM |
|
|
AutoCalculate
-- Where is AutoCalculate in Excel 2007? It used to be on the Task Bar in XP?
...
|
2 |
12/14/2008 5:18:00 AM |
|
|
Emergency: Excel 07: unwanted array inserts itself at startup
I downloaded to my desktop, a sample of work from a coder. It was an array,
10 cells by 10 cells, with a number in each cell; there is a column of "1's",
"2's", etc. to "10"s."
When starting any worksheet, the array inserts itself on top of the existing
data. It eliminates the existing data. When I delete the cells affected by
the array, the original data is also eliminated.
I cannot cr...
|
1 |
12/14/2008 2:10:01 AM |
|
|
runtime error 1004 when using longer decimals
I have this odd problem that I feel is easily solvable by adjusting some
setting but after a few days of struggling and reinstalling excel 2003 I
couldn't figure it out so now I'm posting it here.
I have been using this excel based classification program for a few years
without problems. Now, with a different laptop I suddenly get a runtime error
1004 - application defined or object de...
|
1 |
12/13/2008 8:55:00 PM |
|
|
Is there a way to check the number of different cell formats?
I am developing a large workbook with dozen of worksheets and I had it crash
recently because I exceeded 4,000 different combinations of cell formats. I
found Article #213904 on line that discusses the error message and explains
the reason for the crash. I found the article only somewhat helpful because
it doesn’t say how I can monitor the number of formats as a rebuild the
spreadshe...
|
2 |
12/13/2008 7:06:11 PM |
|
|
Errors with Shared Workbook
We have between 5-10 people using a shared workbook with 15 or so worksheets,
and about 50% of the times someone tries to save, they receive an error
message. Sometime it is: "Your changes could not be saved to -FILENAME-
becuase of a sharing vioation. Try saving to a different file." Sometimes it
lets us save, but then closes the sheet. What's odd is that it doesn't seem
to relate to an...
|
2 |
12/13/2008 7:06:10 PM |
|
|
XL 2007 SP1 - Cell Formats lost when saving
I have a large spreadsheet (approx 30Mb) which has a header sheet and about
30 more data sheets with about 2000 rows of data in each.
The first column of each data sheet is a date (format dd-mmm-yy) and the
rest of the columns are numbers formatted to 2dp.
Whenever I save the workbook, close Excel and reload it, all the formatting
disappears.
There was also once a problem where the...
|
1 |
12/12/2008 5:06:08 PM |