#1   Report Post  
Xalam
 
Posts: n/a
Default #N/A vs Blank Cells

Hi there,
I have a excel file full of formulas and a connection to a BD program.
I use it on two machines and on one it gives me results of incomplete
formulas on a #N/A value, and on the other machine I have a simple blank cell.
The only difference is that one machine as WinXP and the other have Win2000.
Could this be the cause ???

Regards,

Xalam
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

It sounds like you might be using formulas from the Analysis toolpak. Make
sure it's turned on for both PCs. Tools--Addins and choose Analysis
toolpak.
*******************
~Anne Troy

www.OfficeArticles.com


"Xalam" wrote in message
...
Hi there,
I have a excel file full of formulas and a connection to a BD program.
I use it on two machines and on one it gives me results of incomplete
formulas on a #N/A value, and on the other machine I have a simple blank

cell.
The only difference is that one machine as WinXP and the other have

Win2000.
Could this be the cause ???

Regards,

Xalam



  #3   Report Post  
Xalam
 
Posts: n/a
Default

Thanks for the tip, but donĀ“t work.
The BD program is Hyperion.

Regards

"Anne Troy" wrote:

It sounds like you might be using formulas from the Analysis toolpak. Make
sure it's turned on for both PCs. Tools--Addins and choose Analysis
toolpak.
*******************
~Anne Troy

www.OfficeArticles.com


"Xalam" wrote in message
...
Hi there,
I have a excel file full of formulas and a connection to a BD program.
I use it on two machines and on one it gives me results of incomplete
formulas on a #N/A value, and on the other machine I have a simple blank

cell.
The only difference is that one machine as WinXP and the other have

Win2000.
Could this be the cause ???

Regards,

Xalam




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
Skip blank cells in diagrams hlp Charts and Charting in Excel 9 February 24th 06 02:32 PM
Copy down - special to fill only the blank cells Mike Excel Discussion (Misc queries) 3 April 18th 05 10:08 PM
What function can make cells shift up when they are blank? Julie Excel Worksheet Functions 0 March 26th 05 07:31 PM
how do you ignore blank cells Kerry Excel Discussion (Misc queries) 1 February 16th 05 01:55 PM
Non Blank - Blank Cells???? Reggie Excel Discussion (Misc queries) 3 January 12th 05 12:04 AM


All times are GMT +1. The time now is 10:43 AM.

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

About Us

"It's about Microsoft Excel"