How do I work with swedish excel 2003 that uses EDATUM

G

Guest

I have to work with excel workbooks created in Swedish and English using the
analysis toolpak addin that has the same function called EDTUM in Swedish and
EDATE in english, using either version with the opposite spreadsheet causes
the NAME? error to appear. This is causing a problem because the workbooks
are constantly going between myself and my swedish counterparts
 
N

Niek Otten

Hi Dave,

Try to avoid Analysis Toolpak; see

http://www.dicks-blog.com/archives/2004/12/19/replacing-the-analysis-toolpak-addin-part-2/

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have to work with excel workbooks created in Swedish and English using the
| analysis toolpak addin that has the same function called EDTUM in Swedish and
| EDATE in english, using either version with the opposite spreadsheet causes
| the NAME? error to appear. This is causing a problem because the workbooks
| are constantly going between myself and my swedish counterparts
 

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

visual basic Mid() does not work with swedish version of excel 8
LINKED WORKBOOKS - TOTAL CONFUSION 2
networkdays 5
Language problems in Excel 2007 1
The colors should work properly in Shared Excel Workbooks. 1
How do I get Rid of the Circumflex Accent (Caret) 2
analysis toolpak 4
Conflict between VBA and worksheet functions? 0

Top