ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   excel 2007 getting errors with mround (https://www.excelbanter.com/excel-worksheet-functions/202155-excel-2007-getting-errors-mround.html)

JoviGirl

excel 2007 getting errors with mround
 
I have calculations using mround in my spreadsheet and am getting errors all
of a sudden. This is the second time that it has happened to me. I have
opened the spreadsheet alot since I fixed the errors the first time and as I
opened it yesterday, I received an popup that said that "File error: data may
have been lost" and when it opens, the #n/a is displayed where the mround
calc was. Any ideas?

Bob Bridges[_2_]

excel 2007 getting errors with mround
 
When's the last time you rebooted your PC? I'm not being facetious: I tend
to leave mine on for days at a time, forgetting to reboot until something
weird happens. But of course after 3 to 6 days various problems accumulate
and it's worthwhile to restart. Maybe that's all it'll take here.

--- "JoviGirl" wrote:
I have calculations using mround in my spreadsheet and am getting errors all
of a sudden. This is the second time that it has happened to me. I have
opened the spreadsheet alot since I fixed the errors the first time and as I
opened it yesterday, I received an popup that said that "File error: data may
have been lost" and when it opens, the #n/a is displayed where the mround
calc was. Any ideas?


JoviGirl

excel 2007 getting errors with mround
 
I reboot it every night.

"Bob Bridges" wrote:

When's the last time you rebooted your PC? I'm not being facetious: I tend
to leave mine on for days at a time, forgetting to reboot until something
weird happens. But of course after 3 to 6 days various problems accumulate
and it's worthwhile to restart. Maybe that's all it'll take here.

--- "JoviGirl" wrote:
I have calculations using mround in my spreadsheet and am getting errors all
of a sudden. This is the second time that it has happened to me. I have
opened the spreadsheet alot since I fixed the errors the first time and as I
opened it yesterday, I received an popup that said that "File error: data may
have been lost" and when it opens, the #n/a is displayed where the mround
calc was. Any ideas?



All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com