excel viewer #2
Won't microsoft provide a simple, small and fresh Excel Viewer?
Version 97/2k is obsolete, using the 100% of processor time
and simply: it's not good.
I think not everybody buys Excel and Office so there should be
always fresh viewers (like Adobe Acrobat Reader, etc)
"on" <email@example.com> wrote in message
> Won't microsoft provide a simple, small and fresh Excel Viewer?
> Version 97/2k is obsolete, using the 100% of processor time
> and simply: it's not good.
> I think not everybody buys ...why does excel ignore page formating after selecting rows to repe.
I have a Pivot table to which I wish to print excluding the "Page" items but
include the Table headings. I have also set the document to print 1 page
wide by up to 999 pages tall. It previews fine except for when I select the
table headings (row $3$3) to be repeated at the top. After I make that
selection, the preview shows all the data being printed on only 5 pages
instead of 31.
I don't know what I am missing to cause this unexpected result.
...Outlook 2003: Copy Full Names to email display Names
I recently upgraded to Outlook 2003 from 2000.
I believe 2000 used to choose email addresses based on the Full Name
2003 appears to choose based on the Email Display name.
Most of my email Display Names are just the email addresses.
What is the easiest way to copy the Full Name to the email Display
What do you mean by "choose email addresses?" The Display Name has varied
with each version of Outlook, but it is of no consequence. What makes you
think it is?
"orbojeff" <firstname.lastname@example.org> wrote in message
new...Are there any excel template for creating POIs for Garmin units
I'm looking for a template in which I can create points of interest for a
Not that I know of but have you tried the free POI software from Garmin?
Gord Dibben MS Excel MVP
On Sat, 21 Jul 2007 11:24:00 -0700, Fremen <Fremen@discussions.microsoft.com>
>I'm looking for a template in which I can create points of interest for a
...How do you create dual drop down menus in excel 2000?
I can create a single drop down menu, but need to add a qualifier next to
lists on menu. HELP!!!!!!
If drop-down created with Data Validation>List, check out Debra Dalgleish's
site for dependent lists.
Gord Dibben Excel MVP
On Tue, 11 Jan 2005 10:51:03 -0800, "Phlashh"
>I can create a single drop down menu, but need to add a qualifier next to
>lists on menu. HELP!!!!!!
...multiple 3D equations in one excel surface chart
i'm trying to draw in excel multiple 3d equtions(x,y,z) inside of one
excel surface chart
does anyone have simple way of doing it
i have the link for one equation chart but from there i'm little bit
What's the problem? If your data is of 3D type, just plot it as such.
If this information was helpful, please indicate this by clicking ''Yes''.
> hi all
> i'm trying to draw in excel multiple 3d equtions(x,y,z) inside of one
> excel...VB code to import Excel sheet
I'm looking for the VB code to copy an Excel Sheet to an Access 2007
table. The sheet in is a know location.
I also want to clear the Access table prior to importing the Excel Sheet.
Take a look at what Ken Snell has at
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"BobC" <Bob.CallenNoSpamm@cox.net> wrote in message
> I'm looking for the VB code to copy an Excel Sheet to an Access 2007
> table. The she...Excel
When using MS Works I can enter letters and numbers in a cell and the total of the cells in a row will be calculated correctly(for my particular requirement) by ignoring anyone of the cells in the row which has letters and numbers together. All the cells are formated as 'General'.
When I try to do this task in Excel it gives an error in the result cell.
Note that any cell may have a mixture of letters and cells.
Any help would be appreciated.
Submitted via EggHeadCafe - Software Developer Portal of Choice
Bing Search RSS with Silverlight 3 RIA Domain Ser...Pocket Excel Graphic Lost
I developed a spreadsheet that included my company's logo
in Excel 2002. I saved it to my PPC file for conversion by
ActiveSync for my WinCE 2002. I want to use the
spreadsheet from my PPC. I tried both the .png and .jpg
image file types.
The graphic is not on the Pocket Excel version of the
document. Is there a problem with Pocket Excel keeping
graphics? If not, what image format should I use for
graphics in Pocket Excel? Or, is there a switch I need to
Sorry, the correct e-mail address is
>I developed a spreads...Planning training in Excel
I have been tasked to organise training for my company and they have
asked me to use MS Project, which has totally blown my mind. Having
done some investigating Project will not give me the answers that I
need surprisingly, but I am hoping Excel will
I am really trying hard to figure a way of schedulign training for 200
individuals, with 20 different modules (fixed dates) and take into
account holidays. So for instance Joe Bloggs needs to attend Module A,
B & D over the next 3 months, but he also has 2 weeks holiday booked.
There are four other people in his department but I can only all...File size is larger in XP than in Excel 97
Has anyone noticed that excel files that contain imported
data are larger in XP than in 97?
Why, any ideas?
...copy paste problems for chart from excel to power point, solution
I am really having troubles copying excel charts to power point, the charts
are getting messed up after copying and pasting to power point. I tried
everyting, turned off auto scale and selected the don't move or resize with
cells option and still having the same problem, any idea how to fix that?
On Thu, 1 Mar 2007, in microsoft.public.excel.charting,
Jean <Jean@discussions.microsoft.com> said:
>I am really having troubles copying excel charts to power point, the charts
>are getting messed up after copying and pasting to power point. I tried
>everyting, turned ...Excel interfering with dates
How can I stop Excel 2007 interfering with dates?
I have a variety of dates to enter. Some are before 1900, some after. Some
are partial (with no year given); some are just a year. All are entered in
the form 1 Sep 1854 (with some parts missing).
I have defined the format of the cells to be Text/String but Excel ignores
that and corrupts the dates by assuming, if no year is present, that they
are 2011 and if they are after 1900 it converts them to 01/01/2011 format.
How can I force Excel to do what it is told and treat them all as Text?
email@example.com (synonymous...IIF function 02-20-08
Please help me set up the following calculated field. Need a calculated
field that equals Active if the MembershipStatus field is equal to Active and
equals Not Active otherwise.
On Wed, 20 Feb 2008 09:35:04 -0800, JJ wrote:
> Please help me set up the following calculated field. Need a calculated
> field that equals Active if the MembershipStatus field is equal to Active and
> equals Not Active otherwise.
NewColumn:IIf([MembershipStatus] = "Active","Active","Not Active")
Please respond only to this newsgroup.
I do not reply to p...Getting to the last data row in a spreagsheet
Is there any way to find the last row with data in a spreadsheet from with
"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
dim rng as range
set rng = ActiveSheet.Cells(Rows.Count, "A").End(xlUp)
Jonathan Blitz wrote:
> Is there any way to find the last row with data in a spreadsheet from
> with VB?
Try something like the following. Change RowNum to the desired
row number...How can I get the zero values at the end of a chart not to show?
I have a chart getting data from a spreadsheet, where data is added one day
at a time, for an entire month.
After adding the data for the first day, the data point shows, but the line
connecting the data point in the chart immediately drops to zero, since data
for the remaining days is not available.
Is there a way to just have the line connecting the data points show only
where there is data, and not show anything for the upcoming days where data
is not available?
1) use a dynamic chart - see
2) rather than blanks f...Excel 97 #3
I have a list of timecodes, examples,
they are formatted as General
Any ideas how to list them in order of number
Message posted from http://www.ExcelForum.com
You can convert the text to time with the following formula :-
Format as HH:MM:S
Message posted from http://www.ExcelForum.com
I have a table that looks like this right now
I want the previous date in Column B. So this is what I want it to look
like in B
I'm trying to use the DLookUp Function to do this in a query.
This is only a tidbit of what I have, there are hundreds of other dates.
Can someone help me?
SELECT ColumnA, DMax("ColumnA", "MyTable", "ColumnA < " & Format([ColumnA],
On a shared computer, sometimes when you go into excel or word the tab key
will not function. Is there a setting someone is using to disable this key?
How do we change it so the tab key will work properly?
TAB key won't work at all?
No movement whatsoever?
Is the sheet protected?
If moving but one screen at a time, go to Tools>Options>Transition and uncheck
"Transition Navigation Keys".
Gord Dibben Excel MVP
On Wed, 23 Mar 2005 11:49:02 -0800, GBN <GBN@discussions.microsoft.com> wrote:
>On a shared computer, sometimes when you go into excel o...Preflighting Excel files
Is there a way to preflight (check for problems before
printing) Excel files (I already know that Flightcheck
There is a Before_Print event macro that you can use for such checking.
Of course, that macro is blank. You would have to write in the necessary
code to do the checks you want. Can you list the checks and the criteria
for each? Writing the code is straight forward once you have listed the
checks and criteria. HTH Otto
"martindaylor" <firstname.lastname@example.org> wrote in message
news:21d201c49...How do I change the thickness of a bottom boarder in Excel 2002?
In Word you can change the thickness of the line used in boarders - but I can
not change the thickness in Excel. Is there any way to do this? Thanks.
ActiveCell.Borders(xlEdgeBottom).Weight = xlThick 'xlmedium or xlthin
"Dawn" <Dawn@discussions.microsoft.com> wrote in message
> In Word you can change the thickness of the line used in boarders - but I
> not change the thickness in Excel. Is there any way to do this? ...How to Copy Charts and Tables from Excel to Publisher
I'm a new user of Publisher 2003, and I'm working on a 100-page or so
document with text, photos, charts, and tables. I would appreciate advice
about copying charts and tables from an Excel workbook and reducing file
size. Please also recommend which is the correct file format to use when
saving charts, tables, and photos as "pictures".
My Excel workbook has numerous worksheets.
(1) When I try to "copy and paste" a single Excel chart from one worksheet
into Publisher, I get an "object" which shows ALL the worksheets if I double...break links crashes Excel 2002 #2
It appears that it may just be one workbook file. I tried it wit
another file and it did not crash. We primarily use one Excel workboo
as a template. Copies of this file are probably 95% of all the Exce
files we use so it is a big problem for us.
Assuming that it is just this one important file, any ideas how to fi
this workbook so that we can break the links with the toolbar command
EDS's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=879
View this thread: http://www.excelforum.com...Copy an IF function when Inserting new row
I have a column with a list of IF functions in each one.
I need to insert a row, but when I do the IF function is not copied.
Can I insert the row and have the IF function automatically entered
in the new row created?
see your other post
"Philobr" <Philobr@discussions.microsoft.com> schrieb im Newsbeitrag
> I have a column with a list of IF functions in each one.
> I need to insert a row, but when I do the IF function is not copied.
> Can I insert the row and hav...Search Function
Does anyone know why the search function on this discussion group is not
working? I do not know who to report it to. Thks
It comes and goes. This "discussion group" is really a newsgroup with a
"web interface" pasted on the front end. You can bypass it and use a
news reader directly using the link below.
> Does anyone know why the search function on this discussion group is not
> working? I do not know who to report it to. Thks
I use Mozilla's Thunderbird as a new...