|
office 2007 Excel OLAP query Lost Data
I am running a rather large data Pivot Table from Excel 2007 from an SQL
Server 2000 database cube. I am not sure how to appropriately word the
difficulty.
I start the query by adding a dimension to the Excel Pivot then expand it to
the detail, then I add another dimension and expand that both are 2 deep.
This process maxes out my 3.9Gz processor and peaks at about 1.5 Gb of Ram of
2...
|
1 |
12/12/2008 4:26:13 PM |
|
|
Microsoft Office Excel has stopped working
Whenever start Excel 2007 on my new Vista Notebook by double cliking on an
Excel file, or when I want to Close the Excel file I get 90% of the cases the
following error message.
"Microsoft Office Excel has stopped working
A problem caused the Program to stop working correctly.
Windows will close the program and notify you ....."
In Vista's "Problem Reports & Solutions" I have 106 tim...
|
9 |
12/11/2008 6:38:14 PM |
|
|
Excel 2003 horizontal scroll fails, arrows disappear
Since upgrading to Excel 2003 I am getting a repeated problem that after
working on a spreadsheet for a while, the horizontal scroll arrows disappear
and the horizontal scrollbar stops working. Sometimes a patch of
barcode-like vertical bars appear in place of the left hand arrow. When I
try to scroll using the horizontal scrollbar this changes the width of the
window instead of scroll...
|
2 |
12/11/2008 4:54:05 PM |
|
|
How do I open a corruted file in Excel?
The document 'Open audit by district Month End Oct 2008 as of 11-20-2008.xls'
casued a serious error the last time it was opened. Would like to continue
opening it?
This file errors out and is listed as disabled. The file is twice as larger
as a previouse month's file....
|
1 |
12/10/2008 11:54:03 PM |
|
|
you cannot copy or move a group of sheets that contain list ERROR
I get the following error message when I highlight multiple worksheet tabs
and try to copy them.
"you cannot copy or move a group of sheets that contain a list"
--
MjY LeIsFuEs...
|
1 |
12/10/2008 3:12:12 PM |
|
|
Corrupt files (with macro) made in Office 2000
We are experience a lot of problem with Excel files with macro we made in
Office 2002 and that we now open i Office 2002. The files getting corrupt and
we can't open the file again and have to do a restore of the file. We are
experienceing the problem on all of our sites.
This start to when we migrated to a newer version of Office.
Anyone had the same problem? Any ideas?
...
|
1 |
12/10/2008 10:22:03 AM |
|
|
HELP - Excel 2003 cut, copy, paste and paste special problems
I see others have had similar problems on this forum, but I still haven't
found a solution. I use Cut, Copy, Paste and Paste Special via the
right-click menu VERY frequently. Suddenly, the only command I can use from
the right-click menu is Copy. If I want to Paste or Paste Special, I have to
go through the Edit menu or the button on the Standard Toolbar at the top
(Paste and Paste Sp...
|
3 |
12/9/2008 6:36:05 PM |
|
|
When saving shared file get a "cannot access the file" message?
We are using Excel 2007 and have a multi-sheet shared file. Sometimes when a
user goes to save the file they receive a message "Excel cannot access the
file (shows the path - which is correct) and lists three possible reasons:
1. The file name or path does not exist (it does because we have not
changed the path or name and sometimes it does save without issue).
2. The file is being used...
|
1 |
12/9/2008 4:33:10 PM |
|
|
installed office 2003 over office 2007
I was running Office 2007 and was very unhappy with it, so I dedided to get
rid of it. I installed office 2003 over it, and deleted Office 2007 from my
computer. Now when I open up Excel I get this message " c;|program
files\apricot
software\asexcellunit.xla could not be found." I click OK the message goes
away and the program works fine. The message is very annoying. Can you tell
me ...
|
2 |
12/9/2008 2:22:25 PM |
|
|
The UNDO feature does not work in my Excel 2003 (Word is OK)
I am unable to use the UNDO command in Excel as the icon is grayed out. The
only time it is available is when I am keying or editing a cell. This is a
relatively new problem - perhaps since I appled the compatibility pack for
2007 about 1 week ago....
|
3 |
12/9/2008 12:20:01 PM |
|
|
I have 4 GB RAM, 180 GB free HD, Not eough resources error
I have 4 GB RAM, 180 GB free HD space, opened only one Excel document, and
getting "Not eough resources available" error.
Please help me resolve this issue.
Thanks...
|
2 |
12/9/2008 10:56:38 AM |
|
|
List box changes size
MS Excel 2003 service pack 3.
In a spreadsheet one of the list boxes shrinks every time the document is
closed and opened again. The other list box does not change size and the
properties appear to be identical.
How comes?
Karin...
|
2 |
12/9/2008 4:41:01 AM |
|
|
install office 2003 over 2007
when i open excel i get a message c;|program files\apricot
software\asexcellunit.xla could not be found. I click ok and the program
works ok. How do I get rid of this message.
Please help me.
thanks
--
Sandy Lanzet...
|
2 |
12/9/2008 4:22:01 AM |
|
|
Illegal Field Name
I have a macro that is using the Advanced Filter with ranges names defined
inside the filter. I keep getting an error message "The extract range has a
missing or illegal field name" I can't figure out what it is really telling
me. All the field names are in the header row on both the list and copy to
ranges....
|
5 |
12/9/2008 4:08:01 AM |
|
|
cannot edit pivot table on protected sheet
this message box comes up every time i open an excel workbook "cannot edit a
pivot table in a protected workbook" how can i stop it ...
|
2 |
12/9/2008 3:57:00 AM |
|
|
Turning off "invalid ref" messages
Got a quirky one for you. I have a user that uses her spreadsheet in an
unusual way. She has several columns that resove to #ref. Based on whether
or not the column is in #ref status determines if it is calculated or not.
The downside of this is that Excel 2007 keeps coming up with the error
message saying that "your workbook contains several invalid references". We
have tried turni...
|
3 |
12/8/2008 3:11:01 AM |
|
|
Enabling Macro in Excel 2007
Hi there,
I tried out the various instruction in the help section on getting my Macro
to work but none is effective:
I created my own digital signature for self-signing and digitally signing a
macro project. I can see my digital signature under the visual basic screen
(under Tools--> Digital Signatures). It didn't work. When I looked at the
Trusted Publisher list in Trust Center, I c...
|
6 |
12/7/2008 5:52:11 PM |
|
|
when excel is opend, is closed immediately. why? What should I do
when excel is opend, is closed immediately. why? What should I do...
|
1 |
12/5/2008 8:53:01 AM |
|
|
ThisDocument Macro in .xla file gives error
Hi!
I have a few macros that I run when I open a workbook in Excel. They run
fine until I put them in a .xla file. There seems to be a problem
referencing the ActiveWorkbook during the Workbook_Open() macro.
I can setup custom menus fine using the .xla file. The problem occurs when
I use the ActiveWorkbook.Name function during the Workbook_Open(). I get an
"Object variable or w...
|
2 |
12/4/2008 10:49:09 AM |
|
|
Can't open two Exel windows
I'm running Windows XP using Office 2007 and just recently (after using the
Office update site and adding the .pdf file save add-in) Excel will not open
twice (in two seperate windows). I do not have this problem with any other
Office program, just Excel. Additionally, from Windows Explorer, if I
double-click on an Excel file, Windows recognizes the file as an Excel file
and will attem...
|
1 |
12/3/2008 7:28:14 PM |
|
|
after autofilter, delete rows not working correctly
After I autofilter and results show, I highlight rows, rightclick and delete.
In 2003 it only deleted visible rows. Now it deletes everything.
Occasionally it works correctly but I don't know what is causing difference....
|
1 |
12/3/2008 4:01:03 PM |
|
|
Grey area on left side of spreadsheet.
We use Excel spreadsheets to monitor the operation of some experimental pilot
plants. The spreadsheets are set up to bring in data from an Oracle database
once an hour.
The spreadsheets are usually large ones comprising several worksheets each,
and bring in data such as temperatures, pressures and analytical data from
gas chromatographs. This data is used to create graphs and is used ...
|
4 |
12/3/2008 2:19:05 PM |
|
|
Problem with a link formula
I have a worksheet "a" that references cells on another worksheet "b". Cell
A3 in worksheet a finds row of the first cell in column F (worksheet "b")
containing (exactly matching) the string named "Field".
=MATCH(Field,'[Worksheet B.xls]Sheet1'!$F:$F,0)
Cells A4, A5, etc. in worksheet "a" finds the row of the next cell in column
F (worksheet b); that is, the next one after the ...
|
8 |
12/3/2008 12:32:17 PM |
|
|
Error pop-up Message: Too many different cell formats
I can't understand why I get this message & how to get around it. (I do have
a lot of formatted cells in the sheet.)...
|
3 |
12/3/2008 12:31:02 PM |
|
|
VISTA 64 BIT AND EXCEL 2003
I am trying to use a spreadsheet workbook that was written a couple of years
ago. I have the 2003 version of Excel and am running Vista 64 bit version.
I get ###### in every field of the spreadsheet.
Any suggestions?...
|
3 |
12/3/2008 1:37:01 AM |