EOMONTH problem File error: data may have been lost

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nlarson467@gmail.com - 14 Sep 2007 15:25 GMT

I have a file that was created in 2003 that I have been using for over
a year and been using in 2007 for several months. Earlier this week I
added a new sheet that used the EOMONTH function. When I saved and
reopened the file I get "File error: data may have been lost" and all
the cells that have the EOMONTH function are replaced with =#N/A, not
even a formula in those cells. Is there a way to get the formula
back? Anyone else have this problem?

Reply to this Message

Franz Verga - 14 Sep 2007 16:04 GMT

Nel post:1189779955.477553.28800@r34g2000hsd.googlegroups.com,
nlarson467@gmail.com <nlarson467@gmail.com> ha scritto:

> I have a file that was created in 2003 that I have been using for over
> a year and been using in 2007 for several months. Earlier this week I
[quoted text clipped - 3 lines]
> even a formula in those cells. Is there a way to get the formula
> back? Anyone else have this problem?

Hi,

I think you have to load the Analysis Toolpak.

From menu Tools, Add-ins, select Analysis Toolpak and also Analysis Toolpak
VBA.

Signature

(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Reply to this Message

Darren Bartrup - 17 Sep 2007 17:18 GMT

As Franz wrote, you'll need the Anaslysis ToolPak add-in installed.

A better way to ask for the last day of the month is to use the DATE
function instead.

=DATE(2007,9,30) returns 30/09/2007 which is the last day of this month -
ok, nothing suprising there as you typed the date in.

=DATE(2007,10,0) also returns 30/09/2007 which is day 0 of next month - also
equals the last day of this month.

So the formula:
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)
will return the last day of this month.

Thanks to C Pearsons website for that one (I think).

Reply to this Message