How do I work with swedish excel 2003 that uses EDATUM

D

DaveT

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

Excel - Wich Function should I use? 1
Problem with AddIn in Localized/In (Swedish) version of MS Office 1
Excel 2003 #NAME? Error for Swedish Regional option 0
Outlook 2003, Swedish will force i to UPPERCASE. How fix? 2
How do I set focus (and select text) on a text box on a modeless userform? 0
Office 2007 CaptionLabels 2
Word 2003 spelling in Swedish language does not work 6
Help w/ Swedish RPC error 1

Top