calculation property error in 2007


S

SteveDB1

Hi all.
Forthe past 6 months, I've been working on a single workbook for a large
project I'm doing.
About 3 or so months ago I noticed an error when I opened the workbook.
The error states that the workbook must be recovered due to a calculation
error that has occurred.
Since I'm the author of the file, I click ok, and mosey along my way.
Last month, I decided to look into the issue farther, and found that some
worksheet function formulas that I'd written were linked to an earlier
iteration of the workbook.
I found and deleted all of those older, externally "linking" formulas.
It resolved the issue for about 3 weeks. This last week, the issue started
again.
When it happens, I click ok to continue, and it calls up a small window
telling me which worksheets were "corrected" to resolve it.
It also shows a "calculation properties.xml" file.
When I open that it really doesn't tell me anything that I can use to
resolve the issue. Oh, excuse me, it tells me which worksheet is responsible
for the error.
Once in the file, I open the VBA editor to determine the sheet name to see
if I can identify the problem.
When I go to the worksheet and study the formulas I'm not able to find
anything that would make it clear why this is taking place.
There are no externally "linking" formulas, or complex formulas that I can
readily identify.
The next thing is that the calculation property "errors" are not
consistently the same worksheet. It literally changes from day to day.
Also I think of importance is that I'd initially decided to save this
workbook as an XLSM file because the next phase of this project is to create
a macro to auto-update the worksheets within the file from another server
location.
My questions:
1- has anyone had this happen before?
2- if so, any fix?
3- if not, any ideas on what might be causing this to happen? (and yes,
provide me with an email, and I will take screen shots to demonstrate what
I'm talking about.)
4- could the XLSM format be the cause? Until a moment ago I didn't even
think that might be "part of the cause."
If this is not a good enough explanation, please let me know, and I'll try
to clarify further.
Thanks for your time.
Best.
 
Ad

Advertisements

J

JamesEXCELhelp

Fst1 and T. Valko,

Thank You - This worked perfect - I really appreciate it.
 
S

SteveDB1

James,
While I appreciate your response, it seems that you've inadvertantly posted
to me, instead of the post you'd wanted.
Did you have something that could be of assistance to my questions?
Best.
 
Ad

Advertisements

S

SteveDB1

As an addendum to this discussion, I've done the following, and received
comparable results.
1- upon opening the file this morning I decided to make screen shots of each
component. They're now in a word document.
2- I saved the file as an xlsx doc.
3- After making sure I had a viable document that I could not lose any work,
I tried the xlsm file. I clicked no, instead of yes (upon opening when it
asks if I want to repair/recover the file), and it just closed. No other
questions. It just closed.
4- after working on the xlsx formatted version for 45 minutes, I closed, and
reopened it. The issue does not happen.
So I guess my next question would be directed towards the xlsm format.
I know that this format is for built-in macros, within the specific file, as
opposed to being in the add-ins, or as an xlsb file (If I've stated that
incorrectly, please forgive me).
Is there something within that format that results in an internal "check" of
the contents to see if there are any issues/troubles/problems/etc before it
opens?
If that's the case, how can I ensure that they're all resolved-- once and
for all-- so that I won't keep having to deal with it in the future?
Again, thank you for your responses, and time.
Best.
 

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

Top