ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   #N/A vs Blank Cells (https://www.excelbanter.com/excel-discussion-misc-queries/38060-n-vs-blank-cells.html)

Xalam

#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

Anne Troy

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




Xalam

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






All times are GMT +1. The time now is 11:17 AM.

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