|
Opening Excel Files in Excel 2007 only opens application, not the
When I double-click on an excel file both on my desktop and as an attachment
through e-mail (MS Outlook 2007) it only brings up Excel with no workbook
displayed. If I manipulate the window (Minimize, Maximize, R-Click and
select open then cancel) the workbook will display. This is getting to be a
real annoyance and I cannot find anything out on the web to fix it. Any
suggestions are w...
|
5 |
12/31/2008 5:51:00 PM |
|
|
Opening Excel 2007 Binary Files (.xlsb) via OleDb ACE
Hi Fellows,
I found the Excel 2007 Binary format (with extension .xlsb) perfectly
suitable for my needs, since it's fast to load and very compact. I deliver a
bunch of reports in Excel that carries a lot of data, and those reports are
actually being loaded with a IS package.
So I assumed the conversion to this very format, read documentation on
Access Ole DB Provider 12, where it sta...
|
2 |
12/31/2008 3:51:01 PM |
|
|
single TS user unable to open excel files by clicking on them
Good morning, I've got a bit of an odd issue and I'm not sure if it's a
problem with excel or the server, Let me run it by you.
We've been running a terminal services environment with windows server 2008
for while now and yesterday one of the users reports this issue. Whenever he
double clicks on an excel file to open it from the network drive he gets the
error "windows cannot find path/f...
|
1 |
12/31/2008 2:37:01 PM |
|
|
Excel-generated PDF crashes Adobe Reader
When I use the Excel 2007 "save as PDF", the resulting PDF-file crashes Adobe
Reader 9.
Interestingly, the same PDF-file opens fine in Google Docs.
Is anyone else seeing the same problem? Know a work-around?
Thanks,
Rune...
|
1 |
12/31/2008 11:13:01 AM |
|
|
Excel 2007 corrupt files
I am unable to open several Excel 2007 documents (xlsx extension), original
(probably) 2003 documents and I have tried everything from using Excel
repair, to downloading conversion tools and the (advanced) Excel repair
tools, but I am unable to open the documents: Message is "Excel cannot open
the file "namefile" because the file format or file extension is not valid.
Verify that the efi...
|
2 |
12/31/2008 2:20:01 AM |
|
|
"Error accessing file" bug: fixed in Office 2003 SP2, back in SP3?
Hi, I am experiencing the "Error accessing file. Network connection may have
been lost." bug with Excel and PowerPoint 2003 when following the steps
described below. I've duplicated the error on four PCs that have had all
available Microsoft and Office updates applied, and are on Office 2003 SP3.
The article http://support.microsoft.com/default.aspx/kb/842315 says this
error "is correc...
|
1 |
12/30/2008 8:26:24 PM |
|
|
Compatibility Problem between Excel 2003 and 2007
Excel 2007 imcorporated some functions which used to be in a add in previous
versions. This is the case, for example, for the workday() and networkdays()
functions but there are some others.
When I open a 2003 spreadsheet with this functions Excel prompts I'm using
"reserved" names for user defined function which is now internal.
The problem is when I save this 2003 spreadsheet in Exce...
|
1 |
12/30/2008 7:27:03 PM |
|
|
rounding is not consistant
I have asked this before, but I'm still having trouble understanding this.
For example I work in Pharmacuticles and I need to know how long a drug has
been out of the cold room. (I need to record this in hours rounding to the
nearest half hour) the exact rounding method is as follows.
00-14 minutes rounds down to 0.0
15-29 minutes rounds up to 0.5
30-44 minutes rounds down to 0.5
45-59 m...
|
4 |
12/30/2008 5:32:01 PM |
|
|
Decimals???
I noticed that this calcualtion will end up in decimals on excel 2000/2003:
2,736.70 + 112.96 - 2,757.38 = 92.2799999999997
It should be exactly 92.28. Any ideas? ...
|
3 |
12/29/2008 7:20:08 PM |
|
|
My sheet won't preview or print in landscape when I hit landscape
I click the radio button for landscape and nothing changes. The display is
portrate, as is the printout. How do I get it to print landscape?...
|
2 |
12/29/2008 6:29:38 AM |
|
|
XL 2007 SP1, Crashes When Editting Chart Title
This started just two days ago and I do not see any new MS updates that might
have changed anything.
I have workbooks (XL 2003 and XL 2007) that I am now unable to edit the
titles on charts. If I attempt to edit, XL crashes.
This may be an over simplistic question, how can I edit these title without
crashing XL? Is there a recently released update/patch that could be causing
it?
...
|
2 |
12/28/2008 10:54:01 PM |
|
|
Excel 2007 SP1 - Faulty 'compile error' message
When altering XL2007 VBA code in break mode, I often have to declare new
variables (eg with datatypes Boolean and Date) and I frequently get a faulty
'compile error' message saying that there is a "Duplicate Declaration in
Current Scope" when trying to continue.
There is no way out of it except to halt the program and completely restart
it from the beginning.
And, there absolutely d...
|
4 |
12/28/2008 8:20:27 PM |
|
|
Trying to Edit Graph Title Causes Excel to Crash
I am at my wits end... all of a sudden when I try to edit the graph title in
Excel 07 it crashes 100% of time. I was able to edit them two days ago...
very frustrated.
I thought that it might have been corrupt files, but Excel is acting the
same on the files I was working on just two days ago and other files that
haven't been worked on in months.
I am running Excel 2007 (12.0.6331.5...
|
2 |
12/28/2008 8:01:09 PM |
|
|
Error with using Max in a Pivot Table
I have a pivot table in Excel 2007 SP1 that is behaving strangely.
It has a table with 2 labels and date in each row. I create a pivot table to
find the latest date for each combination of labels. I have the 2 labels as
Row Labels and the date in the Value using the Max summarization function. I
am also formating as an outline.
The detailed rows are correct but the total line at the su...
|
2 |
12/24/2008 6:48:40 PM |
|
|
Excel Automatically Opening Old Files
Every time I open Excel, it automatically opens the same five old files which
I have previously worked on. Not the ones from the prior day, but the same
five from some random previous time period. I then have to individually
close down each of the files before I start my current day's work. Any
suggestions?
--
Cheryl G...
|
2 |
12/24/2008 3:18:32 PM |
|
|
Macro's strange behaviour
Hello, until recently I had been using a macro like this and never have had a
problem. Now something has really gone crazy. The macro is this:
Sub ColarLink()
'
' Pastes links in the next spreadsheet
'
' Keyboard Shortcut: Ctrl+j
'
Selection.Copy
ActiveWindow.ActivateNext
ActiveSheet.Paste Link:=True
End Sub
Now. It works the first time. Then when I do it again it acti...
|
2 |
12/22/2008 1:12:01 AM |
|
|
File Errors when Opening Excel
Whenever I open Excel, I get a series of errors. First, "'H:\' could not be
found. Check the spelling of the file name, and verify that the location is
correct. If you are trying to open the file from your list of most recently
used files on the File menu, make sure that the file has not been renamed,
moved, or deleted."
then:
"Cannot access read-only document 'Patronage-Retains".
...
|
2 |
12/21/2008 9:49:01 PM |
|
|
Macro in Workbook Doesn't Work When Opened On Another Computer
In our offices, we have employees working with several versions of Excel. I
created a macro to help production print only the pages it needs from a
workbook, and then saved it inside the workbook so that it would be available
to anyone using the workbook.
However, when the workbook is opened on another computer (although it asks
if macros should be enabled/disabled), the macro does n...
|
3 |
12/21/2008 1:50:01 PM |
|
|
Excel 2003 Freezes on File load (For only 1 User)
I have a number of users with this problem.
When a user tries to load a specific file, that instance of excel freezes
for upwards of 30 minutes. It will eventually open the file. The file begins
to load, and will start showing data, but will hang near the end of the
fill-bar. Other users and even the same user logging in to another PC can
load this file. Another user logging on to this ...
|
1 |
12/19/2008 6:01:02 PM |
|
|
Rank Function - Ranking Array Size Limit
The rank function in Excel is unable to handle large ranking arrays; i.e.
higher than about 2500 entries in the search list.
No mention is made of a maximum number of search entries in the ranking
array in Excel Help for this function.
Is it possible to rank within lists of search entries greater than 2500?...
|
2 |
12/19/2008 5:27:01 PM |
|
|
Configuration/Install/"Office not installed for current user" prob
I have found why this happens. Certain file cleaners (in my case it was
System Mechanic's "junk file" cleaner) DELETE the file OPA11.BAK. This file
is needed by Office for its activation/validation process, which is checked
everytime any Office product is run...at least in Office 2003 and 2007.
Then if you run a registry cleaner afterwards, the corresponding key in
HKLM\SOFTWARE\Microso...
|
1 |
12/19/2008 4:39:00 AM |
|
|
Corrupt file error
I am trying to open a file for work in Excel 2007. It gives me the following
error: "Excel cannot open the file '(filename)'.xlsx' because the file
format or file extension is not valid. Verify that the file has not been
corrupted and that the file extension matches the format of the file."
I've tried the "Open and Repair" option of Excel, but to no avail. I tried
copying it to a f...
|
2 |
12/18/2008 10:26:04 PM |
|
|
Compatibility Mode
When I open an excel file, it is always in compatibility mode and has
attached files. How do I get rid of this?...
|
2 |
12/18/2008 10:23:01 PM |
|
|
What is _1 ?
I've had this workbook that always worked in 2003, but now when I try to copy
a worksheet in 2007 within this workbook I get the following error.
"A formula or sheet you want to move or copy contains a name ‘_1’, which
already exists on the destination worksheet.â€
How can I find these names and remove them or disable this?
Thanks in advance....
|
2 |
12/18/2008 10:22:01 PM |
|
|
Excel 2007 out of memory
I am running Excel 2007 on my laptop and seeming randomly I am encountering
memory problems. My assumption is that the problem is a memory leak within
Excel and has nothing to do with the total overall memory of the system.
Error Message: Excel can not open workbook with available resources
Symptoms: Excel will either open the notebook, graying out portions of the
screen or toolbar...
|
2 |
12/18/2008 5:24:49 AM |