can't open a scrap excel file,
Wed, 3 Mar 2010 17:27:28 +0800
Hi all!
My teacher geve me a file wich is very important.
When i saw it on my teacher's computer, it's excel scrap file, and no
problem for opening. But on my computer it can't be opened. When i double
click it, it says that "file format is unvalid" but i try it on my friend's
computer it can open.
It's ver ...
|
Macro to change pivot field
Wed, 3 Mar 2010 00:11:01 -0800
This is a re-post as my questions hasn't been answered by anyone...
Hi there and thank you in advance for any help.
I have written a macro that changes (hides / shows) fields on a pivot table.
One of these changes the field used for the page fields section of the pivot
table. However, when i add a field to ...
|
Data Validation dropdown list - don't want doubles in list
Tue, 02 Mar 2010 13:37:03 -0500
Hello,
I am using excel 2007 and am creating a drop down list by selecting
"Data Validation" and entering a column I have with different names in
it that are repeated over again in no particular order. I need the list
to only contain each name once to select from though. Is there any easy
way to do this?
T ...
|
lookup from a table in a pivottable
Tue, 2 Mar 2010 05:12:38 -0800 (PST)
Hi
(excel 2007)
I have a regular table (Table13) with some productinformations. I
column M i have the SerialId for the specific item.
I need to check if the SerialId already is in our ERP-system (ax). I
have a pivottable showing all SerialId's from my Ax-table. Excel has
given the pivttable the name Pivottab ...
|
refer to same row in other columns by using entire column in formula
Tue, 2 Mar 2010 04:40:32 -0800 (PST)
Context
I have lots of columns of data which I want to do calculations on,
and i always want to consider the same row only.
I would like to use names in the formulas to make it easier to keep
track of which columns are being used. So it's not as if I have
a problem at the moment, just that it could be easier ...
|
File-list generated from folder including attributes
Tue, 2 Mar 2010 01:41:30 -0800 (PST)
Hey guys
My macro generates a file-name list with accordingly attributes as
"size", "Accessed date".
My problem is to expand this Explorer-information with attributes:
"Author" and "Owner".
I dont know/cantv find the code...... maybe file.author or
something????+
Here is my macro:
Sub SelectFiles(ByV ...
|
Villes fran?aises...
Tue, 2 Mar 2010 07:48:13 +0100
Bonjour à tous,
Qui aurait en magasin la liste des villes françaises de + de 10 000
habitants (avec le code postal) ?
Note : Tout format de fichier (Excel, Texte, Etc.) convient.
Si certains sont intéressés, j'ai la liste de toutes les communes françaises
à dispo. (fichier .mdb)
D'avance merci,
jpg
...
|
|
|
Excel spreadsheet to web page issues
Mon, 01 Mar 2010 22:36:30 -0700
I don't know if this the right place to inquire.. but for a lack of
any other places...
I have a multi sheet spreadsheet (Excel 2003) that I have saved as an
htm file and posted it on my web site. I am pleased with the results
except for two issues that I would like to tweak.
1. The sheet that had focus whe ...
|
Excel compatibiliy with newer version
Mon, 1 Mar 2010 18:50:01 -0800
I have Office 2000 and I understand there is a patch you can download where
you can open files from newer versions of Excel. I can't seem to find
anything like that on the MSOffice downloads. Can anyone point me in the
right direction?
Thanks and God Bless!!
--
Sabrena Vick ...
|
Chart blanks
Mon, 1 Mar 2010 20:42:21 -0000
Hi
I have a chart with 2 lines on it. One has 52 data points and is last year's
data. This year's line has, say, only 20 points. I would like this years
line just to stop after the 20 points but it continues showing 0 for the
rest of year. How do I get it just to not plot!
Thanks
Max
...
|
