Formula error when saving
Thanks for the reply.
I posted it again in a more detail manner hoping to get a better answer.. The response to the previous post: "be sure that when you see the Save As Dialog, you have the "Save as type:" set to the value of "Microsoft Excel Workbook (*.xls)" in order that you save the file in the most newer format for Excel Files. If you need to save it in older formats, then you will lost some formatting or functions information. Is irrelevant These same workbooks have been used for years using the same version and saving the same way. Please read the post again and see if you have any other suggestions. Many thanks, Brady Snow Mckinney -----Original Message----- You have one response at your other post. Brady Snow wrote: Thanks to all that participate in these NG. They are very helpful. When a user is saving a workbook in Excel 2000 with many calculations and references, she is getting the following error: "A formula in a cell (name:year) could not be converted because it contains a function that is not available in the fileformat to which you are saving. She has been using this workbook for years and just started seening this error. When when clicks <OK it continues on and says that she has x amout of error in workbook. Has anybody out there had any experience with this error. And what is cell (name:year)? Regards- Brady Snow Mckinney, Texas -- Dave Peterson . |
Formula error when saving
I just have guesses/questions.
Are there any range names in your workbook? You may want to try Jan Karel Pieterse, Charles Williams and Matthew Henson's utility called NameManager.Zip from http://www.bmsltd.co.uk/mvp. To eliminate any chance that there's a problem with a workbook name. Does that (name:year) look like it's part of your workbook or a part of a standard error message. (I don't think I've seen anything like it.) Can you play a little with a copy of the workbook? Eliminate some worksheets and try saving. Maybe you can isolate the worksheet with the problem. Once you do that, you could divide the worksheet in half and clear that. If the error goes away, then keep that half and toss the other. Keep eliminating the half that didn't cause the problem. Is the workbook small? If it's small (or you can make it small and still get the error) and you remove any proprietary info, you can send it to me. (no promise that I can find anything though.) What version of excel are you using? And just to be more irritating, are you sure that the user really saved in the current version of excel? brady snow wrote: Thanks for the reply. I posted it again in a more detail manner hoping to get a better answer.. The response to the previous post: "be sure that when you see the Save As Dialog, you have the "Save as type:" set to the value of "Microsoft Excel Workbook (*.xls)" in order that you save the file in the most newer format for Excel Files. If you need to save it in older formats, then you will lost some formatting or functions information. Is irrelevant These same workbooks have been used for years using the same version and saving the same way. Please read the post again and see if you have any other suggestions. Many thanks, Brady Snow Mckinney -----Original Message----- You have one response at your other post. Brady Snow wrote: Thanks to all that participate in these NG. They are very helpful. When a user is saving a workbook in Excel 2000 with many calculations and references, she is getting the following error: "A formula in a cell (name:year) could not be converted because it contains a function that is not available in the fileformat to which you are saving. She has been using this workbook for years and just started seening this error. When when clicks <OK it continues on and says that she has x amout of error in workbook. Has anybody out there had any experience with this error. And what is cell (name:year)? Regards- Brady Snow Mckinney, Texas -- Dave Peterson . -- Dave Peterson |
All times are GMT +1. The time now is 04:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com