LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default MROUND replaced with #N/A in Excel 2007

I am one of the first people in my organisation to have Office 2007
installed - the majority of other users are still on Office 2003. As a
result, I have to keep all my workbooks in Office 2003 format.

The problem I have is that the message 'File error: Data my be lost'
is frequently displayed when I open one of these workbooks and then
several formulae are replaced with '#N/A'. I then have to go through
and re-enter all the formulae. It's worth noting that this doesn't
happen every time I open a workbook but after it's happened to a
particular workbook once it will happen every time I open that file,
even if I don't save it.

It would seem that it's got something to do with the functions MROUND
and NETWORKDAYS, which used to be included in the Excel 2003 Analysis
TookPak. Does anyone know of any add-in, patch, etc that I can
installed to get round this as I use these functions all the time and
it's getting very tedious!

Thanks

Steve
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I recover replaced file in excel? Gorby Excel Discussion (Misc queries) 2 September 16th 08 09:29 PM
excel 2007 getting errors with mround JoviGirl Excel Worksheet Functions 2 September 12th 08 11:00 AM
Formula replaced with =#N/A in 2007 - why? Alan Smith Excel Discussion (Misc queries) 8 January 23rd 08 01:56 PM
Accidently replaced a spreadsheet that I did not want replaced T Excel Discussion (Misc queries) 2 June 28th 07 04:52 PM
mround function: is there a download for Excel 2002? David of the Orchard Excel Worksheet Functions 2 March 6th 06 06:32 PM


All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"