EXCEL 2007 and 2002

[DA]

I created a file in EXCEL 2002 and it is being used by someone with
2007. He got a "data may have been lost" when he opened the file. I
asked him to send me back a file he created using the file I sent (so
I could try to find the source of the problem, knowing that I might
not, given that I had only 2002, but it was worth a look) but when I
received it, all that was visible was one worksheet with:

Permission for this workbook is currently restricted. This workbook
can only be opened by using Microsoft Office 2003 or later. You can
request the author of the workbook to send a copy that can be read
using the Rights Management Add-on for Internet Explorer.

I found a Microsoft knowledge base article on this:

http://support.microsoft.com/kb/841423

but it suggests the problem is when opening a 2003 file with an office
2004 for mac version, not between PC versions.

Though I understand that Office 2007 is a major change from priors, I
was led to believe that 2003 was virtually the same as 2002. I've
never had a problem before trading files with people who had 2003.

Since his file was created with 2007, not 2003, I wonder if 2007
versus 2002 is the problem, not 2003 versus 2002. And, if so, would I
still have a problem trying to open this 2007 file even with 2003.

I assume that, if i ask him to send me his file after saving it as a
2002 file, I will be able to open it. Do you agree?

Does anyone know what could be the source of the "data may have been
lost". I sent him two test files with all the referecnes to add-in
functions removed (although the VBA add-in box could still be a
culprit) since i read that such could cause problems, but he still got
the message.

Thanks
Dean

 

[Don Guillett]

??? Perhaps your xl2002 file should JUST be saved as .xls. I do not have
2002 installed but I do have 2003 and 2007 so if you would like to send THE
bad 2002 file to my address below, I will take a look.

 

[DA]

I'm a little confused by what you say. Are you refering to the file
he altered (in 2007) and resaved? If you are only refering to the
original file I created, when I saved the file, I just save it as the
default of Microsoft Excel Workbook.

I will ask but, unfortunately, this gent will almost surely not allow
me to send the file to anyone. To wit, he loves 2007 becasue of all
the protections it has, whereas I've rejected it due to some bugs I
saw when i first got it, plus I wonder if these protections are
disabled as easily as the worksheet/workbook password protections of
earlier EXCEL versions are.

I do really appreciate the kind offer. I have a hunch that, if he
just resends me his file, saved as a 95-2002 file, I will be able to
read it and do a before versus aftre file and uncover what, if
anything, has really been lost.

I have that lovely compare.xla rotuine you folks told me about long
ago - what a godsend that was!

Let me see what he says.

Thanks!
Dean

 

[Don Guillett]

http://www.google.com/search?sourceid=navclient&ie=UTF-8&rlz=1T4GFRD_en___US219&q=converters:excel

 

[DA]

I am starting to suspect that the data loss has to do with the
apparent link to atpvbaen.xla which actually exists in my original
file! I went to tools, add-ins, and diabled it, even restarted EXCEL
but the link is still there when i restart excel and re-open the
original file. My only options under "edit links: are to opne source,
or check status, niether of which does anything. All the others are
hushed.

It seems like there is no way to remove this link from the file, an
add-in that, by the way, I don't need. Do you think rebooting my
computer will help?

Thanks again!
Dean

 

[DA]

Oops, I could not remove the link becasue all worksheets (though not
workbook, and you wouldn't think this vba thing would care about
worksheets) were protected, strangely,. When I unprotected them all,
now i can break the link, so ingore my last post, please.

Sorry
Dean

 

[DA]

Ah, but still a problem. It seems that xnpv function requires
atpvbaen.xla whihc surprises me becasue I thought that atpvbaen.xla
(analysis toolpak VBA) was only for functions you wanted to have thru
VBA. Otherwise, for spreadsheet cells, I thought it was funcres
(analysis toolpak). But, alas, this appears not to be true.

I do need that XNPV function.

Can anyone comment?

It looks like I might have to recreate some parts of my 2002 file in
EXCEL 2007, in order to combat this data loss caused by opening a 2002
file with 2007. There is something in EXCEL 2002 that 2007 does not
recognize and it seem clear it is related to these add-in functions.

Thanks!
Dean

 

[DA]

For what it's worth, I found another URL that addresses a similar
problem wherein EXCEL 2007 turns these 2002 version add-in functions
into =#N/A in the formula bar, even though the cell shows the correct
result, that is, until you change something, at which point it becomes
even more obvious that the formulas have been lost. Or tries to
associate them with atpvbaen.xla.

http://groups.google.com/group/micr...573fe8f1c77/64fcd535b9b65810#64fcd535b9b65810

I even stumbled upon an old post of my own that ended with a query
that was never answered:

<< What I'd really like to know if why atpvbaen insists on stealing
away the eomonth function that apparently, is already in funcres.xls.
If it is really just for VBA, how does it even find it? >>

Help, please!
Dean