Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation property error in 2007
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation property error in 2007
Fst1 and T. Valko,
Thank You - This worked perfect - I really appreciate it. "SteveDB1" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation property error in 2007
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. "JamesEXCELhelp" wrote: Fst1 and T. Valko, Thank You - This worked perfect - I really appreciate it. "SteveDB1" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation property error in 2007
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. "SteveDB1" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to match property error | Excel Discussion (Misc queries) | |||
XValues Property and 400 Error | Charts and Charting in Excel | |||
2007 Beta TR calculation error / bug | Excel Discussion (Misc queries) | |||
Error setting shape text property | Charts and Charting in Excel | |||
Object doesn't support this property or method (Error 438) | Excel Discussion (Misc queries) |