Localisation problem with pivot tables
Wed, 28 May 2008 11:11:02 -0700
Hello,
I have a really annoying problem:
When adding a pivot table via PivotTables.Add I have to specify the
destination in the row/column notation, e.g. R3C1.
This works on english installations but not on german ones. There I have to
use Z3S1!!
I am using C# to automate Excel.
Before calling any Excel m ...
|
Corrupted Excel Display
Wed, 28 May 2008 07:37:00 -0700
Windows XP Professional, Excel 2003, 2GB RAM
When our heavy Excel user has five or more instances of Excel open, usually,
the display begins to fail. It's as if each sheet were composed of tiles and
the tiles were randomly moved around. Also, the programs no longer respond to
mouse clicks or keystrokes.
...
|
Excel 2007 and Name Conflict Issue
Tue, 27 May 2008 11:19:00 -0700
I currently have Office 2007 and when I try to open an excel file created in
Excel 2003, I get the message: "Name Conflict...Name cannot be the same as a
built in name. Old Name: Print_Area."
Why is this coming up and what is the resolution? I heard there is a patch
for this but can't find it.
Thanks! ...
|
Last column no.
Tue, 27 May 2008 04:00:00 -0700
Hi,
Need a help.
1. Macro to get final Last row no. from the user
2. Calculate the TAT (diff. between any two column) with the last row no.
Your help on this would be highly appreciated.
Bye,
Sivassou. ...
|
smtp
Tue, 27 May 2008 03:55:00 -0700
how to setup to hotmail. com\outlock exp
smtp&pop ...
|
Excel 2007 auto-recovery / auto-save?
Fri, 23 May 2008 14:19:01 -0700
I have an large spreadsheet where the data is populated via a connection to
databases via MS Query. In addition to this data there are various lookup
tables used to enhance the data downloaded from the query. This issue that i
am having is if i need to make an adjustment to one of the lookup tables
excel a ...
|
editing setup defaults
Fri, 23 May 2008 11:06:00 -0700
In Excel 2002, when I open an existing worksheet, it automatically opens a
blank excel template. How do I turn this off? ...
|
|
|
Can you set up a global footer (filename & ext) on all wsheets
Thu, 22 May 2008 07:31:01 -0700
Is there a way to set a global footer for all workbooks to print the filename
and extention at the bottom of the sheet without setting it for each workbook
you have and for new ones opened? ...
|
where the archieve folder deleted mails are stored
Thu, 22 May 2008 04:54:00 -0700
In outlook i used to keep all the mails in Archieve folder. Two days back i
am not able to open the archieve folder and the error msg shows as "The
Server is not availble". I checked the same with my administrator and they
said the server link is available. In that Archieve folder i have more than 2
years ma ...
|
Formatting cells
Wed, 21 May 2008 19:09:25 -0700
I notice that when I use the "rich" graphics options available in EXCEL to
format presentations and worksheets, I occasionally run up against a common
error message: "Too many cell formats!"
Now to be frank, I rarely come across this until workbooks get to be about
2.5 MB or over 3-7 worksheets deep. Ina ...
|
