excel 2007 getting errors with mround

J

JoviGirl

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?
 
B

Bob Bridges

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.
 
J

JoviGirl

I reboot it every night.

Bob Bridges said:
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.
 
A

achnzl

I have exactly the same problem and since I use the mround function a lot it
is very very annoying to troll through the entire spredsheet to correct it. I
would really appreciate a solution to this problem too!
 

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