Excel Formula in XP and NT

  • Thread starter Thread starter msenquiry
  • Start date Start date
M

msenquiry

Hi all,

I have an excel macro running in NT4.0 + Office97 and I have use some
formula such as EMONTH...

After upgrade to XP + Office97, I find the formula is less than in NT, eg.
Emonth cannot be find in the "Date and Time" formula.

Is it because of compatiable of the XP and Office97? Will Office2000 or
OfficeXP resolve this?

Thanks,
Jack
 
Hi Jack

EOMONTH is one of the analysis tool-pak add-in formulas
go to tools / add-ins - check analysis tool-pak to enable.

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Access data into Excel spreadsheet 1
Problem installing office97 in XP 3
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Excel file inflation 3
Organization charts in OfficeXP 2
word97 encounters a problem and needs to close in XP 1
Will Office97 Work on XP-Pro??? 1
Q: References: upgraded office, library changed causing errors 1

Back
Top