Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 9th 08, 11:21 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
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

  #2   Report Post  
Old October 9th 08, 01:03 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default MROUND replaced with #N/A in Excel 2007

See your other post, and please don't multi-post.

Pete

On Oct 9, 11:21*am, Steve McDonald wrote:
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


  #3   Report Post  
Old October 9th 08, 01:35 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,651
Default MROUND replaced with #N/A in Excel 2007

On Thu, 9 Oct 2008 03:21:02 -0700 (PDT), Steve McDonald
wrote:

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



I don't know why you are getting the #N/A error. However, both MROUND and
NETWORKDAYS (as well as all of the other ATP functions) are present in Excel
2007 natively.

And saving a workbook that contains that function seems to work OK on my system
(saving from Excel 2007 in compatibility mode; closing the file; then
reopening).
--ron


Reply
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 02:22 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017