Average a text file issue Excel 2003

I am assisting a customer who was recently upgraded from Office 2000 to 
Office 2003. The customer claims this formula worked fine in Excel 2000. He 
is averaging data files which are text with a *.dat extention. The formulas 
look like this: =AVERAGE('C:\Path_to_data_file\[R0131.dat]R0131'!$G$2:$G$120) 
When the file is opened he is prompted as he should be to update links. If 
the *.dat file has data in the g2:g120 range, the average formula works fine 
and updates when the links update. If the *.dat file has any null values 
towards the end of the file or if data is in the g2:g110 range a #REF! error 
is returned. If the links are opened, and the source opened, then the formula 
seems to update properly. There are thousands of these links in a sheet, the 
*.dat files are dynamic and it is not practical to open the source on every 
link. The *.dat files are constantly updated so it is not practical to 
convert them to another format. Is there any way to tell this formula to 
ignore null values in this data range? Is there another fix for this issue?
TIA
George
0
11/15/2004 4:08:04 PM
excel.misc 78881 articles. 5 followers. Follow

6 Replies
679 Views

Similar Articles

[PageSpeed] 37

It surprises me that this actually worked at all.

In my simple test, I create a workbook with just one worksheet.  I put test date
in G1:G29.  I put this formula in another workbook.

=SUM(book1!$G$1:$G$29)

When I closed book1 and saved it as a .dat file, I got this formula.

=SUM('C:\My Documents\excel\[book1.Dat]book1'!$G$1:$G$29)

But excel wouldn't update it unless the workbook was open.  I got an error
message that said excel couldn't update one or more links in this workbook when
I just pretended to edit the formula (F2 followed by an edit).

The only way I know how to do this is to open the .dat file, convert to .xls and
save it and have those links point at the .xls file.

I've never used it, but you may want to try using:
Data|query to retrieve values from a text file 
(I don't know if this would work, though.)

One more alternative:
I would think that you could write a UDF that parsed your text file into just
the stuff you cared about and then brought the values back (sum/count =
average), but with 1000's, I would think that even that would be a bear to
update.

And you'd have to know how to parse the line, too.  (comma/space/tab delimited
or fixed width).




George Wilson wrote:
> 
> I am assisting a customer who was recently upgraded from Office 2000 to
> Office 2003. The customer claims this formula worked fine in Excel 2000. He
> is averaging data files which are text with a *.dat extention. The formulas
> look like this: =AVERAGE('C:\Path_to_data_file\[R0131.dat]R0131'!$G$2:$G$120)
> When the file is opened he is prompted as he should be to update links. If
> the *.dat file has data in the g2:g120 range, the average formula works fine
> and updates when the links update. If the *.dat file has any null values
> towards the end of the file or if data is in the g2:g110 range a #REF! error
> is returned. If the links are opened, and the source opened, then the formula
> seems to update properly. There are thousands of these links in a sheet, the
> *.dat files are dynamic and it is not practical to open the source on every
> link. The *.dat files are constantly updated so it is not practical to
> convert them to another format. Is there any way to tell this formula to
> ignore null values in this data range? Is there another fix for this issue?
> TIA
> George

-- 

Dave Peterson
0
ec357201 (5290)
11/15/2004 11:15:05 PM
Ps.  I used xl2002 in my testing.

When I got the message that the link couldn't be updated, the value didn't
change.  Any chance that the values never changed when those files were closed
(and the averages would have been in error)???



George Wilson wrote:
> 
> I am assisting a customer who was recently upgraded from Office 2000 to
> Office 2003. The customer claims this formula worked fine in Excel 2000. He
> is averaging data files which are text with a *.dat extention. The formulas
> look like this: =AVERAGE('C:\Path_to_data_file\[R0131.dat]R0131'!$G$2:$G$120)
> When the file is opened he is prompted as he should be to update links. If
> the *.dat file has data in the g2:g120 range, the average formula works fine
> and updates when the links update. If the *.dat file has any null values
> towards the end of the file or if data is in the g2:g110 range a #REF! error
> is returned. If the links are opened, and the source opened, then the formula
> seems to update properly. There are thousands of these links in a sheet, the
> *.dat files are dynamic and it is not practical to open the source on every
> link. The *.dat files are constantly updated so it is not practical to
> convert them to another format. Is there any way to tell this formula to
> ignore null values in this data range? Is there another fix for this issue?
> TIA
> George

-- 

Dave Peterson
0
ec357201 (5290)
11/15/2004 11:16:18 PM
Some of these are updating just fine and it is consistant that the links that 
do not average and update exceed the range of data in the file. all the other 
links update and calculate just fine. What is a UDF? Can a DAT file be 
converted easily?

"Dave Peterson" wrote:

> It surprises me that this actually worked at all.
> 
> In my simple test, I create a workbook with just one worksheet.  I put test date
> in G1:G29.  I put this formula in another workbook.
> 
> =SUM(book1!$G$1:$G$29)
> 
> When I closed book1 and saved it as a .dat file, I got this formula.
> 
> =SUM('C:\My Documents\excel\[book1.Dat]book1'!$G$1:$G$29)
> 
> But excel wouldn't update it unless the workbook was open.  I got an error
> message that said excel couldn't update one or more links in this workbook when
> I just pretended to edit the formula (F2 followed by an edit).
> 
> The only way I know how to do this is to open the .dat file, convert to .xls and
> save it and have those links point at the .xls file.
> 
> I've never used it, but you may want to try using:
> Data|query to retrieve values from a text file 
> (I don't know if this would work, though.)
> 
> One more alternative:
> I would think that you could write a UDF that parsed your text file into just
> the stuff you cared about and then brought the values back (sum/count =
> average), but with 1000's, I would think that even that would be a bear to
> update.
> 
> And you'd have to know how to parse the line, too.  (comma/space/tab delimited
> or fixed width).
> 
> 
> 
> 
> George Wilson wrote:
> > 
> > I am assisting a customer who was recently upgraded from Office 2000 to
> > Office 2003. The customer claims this formula worked fine in Excel 2000. He
> > is averaging data files which are text with a *.dat extention. The formulas
> > look like this: =AVERAGE('C:\Path_to_data_file\[R0131.dat]R0131'!$G$2:$G$120)
> > When the file is opened he is prompted as he should be to update links. If
> > the *.dat file has data in the g2:g120 range, the average formula works fine
> > and updates when the links update. If the *.dat file has any null values
> > towards the end of the file or if data is in the g2:g110 range a #REF! error
> > is returned. If the links are opened, and the source opened, then the formula
> > seems to update properly. There are thousands of these links in a sheet, the
> > *.dat files are dynamic and it is not practical to open the source on every
> > link. The *.dat files are constantly updated so it is not practical to
> > convert them to another format. Is there any way to tell this formula to
> > ignore null values in this data range? Is there another fix for this issue?
> > TIA
> > George
> 
> -- 
> 
> Dave Peterson
> 
0
11/16/2004 12:47:09 AM
Another strange occourance, is when I open the link manager and open source 
on one of the links that updates, all of the data seems to fall into the 
correct fields. When I open the source on the links with the #REF! errors it 
seems to have imported all the data for each row into the first cell of the 
row. The customer claims all this was working fine before he upgraded to 
2003, I have to trust that this is correct.

"Dave Peterson" wrote:

> Ps.  I used xl2002 in my testing.
> 
> When I got the message that the link couldn't be updated, the value didn't
> change.  Any chance that the values never changed when those files were closed
> (and the averages would have been in error)???
> 
> 
> 
> George Wilson wrote:
> > 
> > I am assisting a customer who was recently upgraded from Office 2000 to
> > Office 2003. The customer claims this formula worked fine in Excel 2000. He
> > is averaging data files which are text with a *.dat extention. The formulas
> > look like this: =AVERAGE('C:\Path_to_data_file\[R0131.dat]R0131'!$G$2:$G$120)
> > When the file is opened he is prompted as he should be to update links. If
> > the *.dat file has data in the g2:g120 range, the average formula works fine
> > and updates when the links update. If the *.dat file has any null values
> > towards the end of the file or if data is in the g2:g110 range a #REF! error
> > is returned. If the links are opened, and the source opened, then the formula
> > seems to update properly. There are thousands of these links in a sheet, the
> > *.dat files are dynamic and it is not practical to open the source on every
> > link. The *.dat files are constantly updated so it is not practical to
> > convert them to another format. Is there any way to tell this formula to
> > ignore null values in this data range? Is there another fix for this issue?
> > TIA
> > George
> 
> -- 
> 
> Dave Peterson
> 
0
11/16/2004 12:54:03 AM
A UDF is a user defined function.  It's VBA code that can be written to open the
..dat file, read through the records, extract the data and return the value
(average) to the cell with the formula in it.

Can .dat files be converted easily?

Individually, I'd say yeah--since you said you could just open them and they go
to the correct columns.

But if you really have 1000's, I think you'd need a macro to do it--and adjust
the links.

George Wilson wrote:
> 
> Some of these are updating just fine and it is consistant that the links that
> do not average and update exceed the range of data in the file. all the other
> links update and calculate just fine. What is a UDF? Can a DAT file be
> converted easily?
> 
> "Dave Peterson" wrote:
> 
> > It surprises me that this actually worked at all.
> >
> > In my simple test, I create a workbook with just one worksheet.  I put test date
> > in G1:G29.  I put this formula in another workbook.
> >
> > =SUM(book1!$G$1:$G$29)
> >
> > When I closed book1 and saved it as a .dat file, I got this formula.
> >
> > =SUM('C:\My Documents\excel\[book1.Dat]book1'!$G$1:$G$29)
> >
> > But excel wouldn't update it unless the workbook was open.  I got an error
> > message that said excel couldn't update one or more links in this workbook when
> > I just pretended to edit the formula (F2 followed by an edit).
> >
> > The only way I know how to do this is to open the .dat file, convert to .xls and
> > save it and have those links point at the .xls file.
> >
> > I've never used it, but you may want to try using:
> > Data|query to retrieve values from a text file
> > (I don't know if this would work, though.)
> >
> > One more alternative:
> > I would think that you could write a UDF that parsed your text file into just
> > the stuff you cared about and then brought the values back (sum/count =
> > average), but with 1000's, I would think that even that would be a bear to
> > update.
> >
> > And you'd have to know how to parse the line, too.  (comma/space/tab delimited
> > or fixed width).
> >
> >
> >
> >
> > George Wilson wrote:
> > >
> > > I am assisting a customer who was recently upgraded from Office 2000 to
> > > Office 2003. The customer claims this formula worked fine in Excel 2000. He
> > > is averaging data files which are text with a *.dat extention. The formulas
> > > look like this: =AVERAGE('C:\Path_to_data_file\[R0131.dat]R0131'!$G$2:$G$120)
> > > When the file is opened he is prompted as he should be to update links. If
> > > the *.dat file has data in the g2:g120 range, the average formula works fine
> > > and updates when the links update. If the *.dat file has any null values
> > > towards the end of the file or if data is in the g2:g110 range a #REF! error
> > > is returned. If the links are opened, and the source opened, then the formula
> > > seems to update properly. There are thousands of these links in a sheet, the
> > > *.dat files are dynamic and it is not practical to open the source on every
> > > link. The *.dat files are constantly updated so it is not practical to
> > > convert them to another format. Is there any way to tell this formula to
> > > ignore null values in this data range? Is there another fix for this issue?
> > > TIA
> > > George
> >
> > --
> >
> > Dave Peterson
> >

-- 

Dave Peterson
0
ec357201 (5290)
11/16/2004 1:37:17 AM
(to me) this sounds like that the links were never updated after they were
created.

xl2002+ likes to recalculate workbooks when you open them if they were created
in
earlier versions of excel.  

If you choose not to update the links, then xl2002+ return #ref! errors.  In
earlier versions, the value stayed the same--but wasn't updated.

I don't have xl2k available, but I'd bet that although the formulas looked ok,
they were really out of date once the .dat file got changed--if the .dat file
wasn't opened subsequently.

===
When you did the link stuff (edit|links???), did you click the "update values"
button or the "open source" button.

I got errors with the "update values" button.  I got updated values if I did
"open source".

(If you can look at the .dat file in a text editor, can you describe what you
see.  I'm guessing that it's simply a tab delimited text file (or something like
this).)

And if you want a macro to open each .dat file and resave each as .xls, you'll
have to give a little information.

Are all the .dat files in one folder?
And what is the layout of those .dat files?



George Wilson wrote:
> 
> Another strange occourance, is when I open the link manager and open source
> on one of the links that updates, all of the data seems to fall into the
> correct fields. When I open the source on the links with the #REF! errors it
> seems to have imported all the data for each row into the first cell of the
> row. The customer claims all this was working fine before he upgraded to
> 2003, I have to trust that this is correct.
> 
> "Dave Peterson" wrote:
> 
> > Ps.  I used xl2002 in my testing.
> >
> > When I got the message that the link couldn't be updated, the value didn't
> > change.  Any chance that the values never changed when those files were closed
> > (and the averages would have been in error)???
> >
> >
> >
> > George Wilson wrote:
> > >
> > > I am assisting a customer who was recently upgraded from Office 2000 to
> > > Office 2003. The customer claims this formula worked fine in Excel 2000. He
> > > is averaging data files which are text with a *.dat extention. The formulas
> > > look like this: =AVERAGE('C:\Path_to_data_file\[R0131.dat]R0131'!$G$2:$G$120)
> > > When the file is opened he is prompted as he should be to update links. If
> > > the *.dat file has data in the g2:g120 range, the average formula works fine
> > > and updates when the links update. If the *.dat file has any null values
> > > towards the end of the file or if data is in the g2:g110 range a #REF! error
> > > is returned. If the links are opened, and the source opened, then the formula
> > > seems to update properly. There are thousands of these links in a sheet, the
> > > *.dat files are dynamic and it is not practical to open the source on every
> > > link. The *.dat files are constantly updated so it is not practical to
> > > convert them to another format. Is there any way to tell this formula to
> > > ignore null values in this data range? Is there another fix for this issue?
> > > TIA
> > > George
> >
> > --
> >
> > Dave Peterson
> >

-- 

Dave Peterson
0
ec357201 (5290)
11/16/2004 1:44:29 AM
Reply:

Similar Artilces:

VBScript Issues (and the missing auto configuration)
Greetings: I used the script from the MS KB site to add a corporate sig to all outgoing SMTP email. It works when my AV software sends an alert and it works when our sole Mac user sends email via Outlook Express. This may not be related but, when I use logon scripts to map printers, etc, I get a "no such printer" (paraphrase) type of error when I know that the printer URL is correct. The printer mapping at login script worked once - when I wrote it and tested it. Running on the same machine, nor any other on the network now, no luck. Back to the sig issue, none of th...

Averaging numbers but ignoring < and
I have a column of data as illustrated below than contains numbers, blank cells, dashes and < entries. Is it possible to average only the numbers ensuring that the divsor is the number of cells that contain number entreis rather than all cells containing an entry (eg for below example answer should be 0.137) 0.3 <0.001 0.01 <0.01 0.1 Thank you On Wed, 23 Feb 2005 06:29:03 -0800, KIM <KIM@discussions.microsoft.com> wrote: >I have a column of data as illustrated below than contains numbers, blank >cells, dashes and < entries. Is it possible to average only ...

File Association problem
Hi, I'm using Windows 98 Second Edition and VC6.0. I have an mfc/sdi app which runs fine; both its debug and release versions, when executed using Run, its shortcuts, the Start button, etc. I used Install Shield to install the release version of my app. I have associated a particular file extension with my app and verified this by going into Windows Explorer / View / Options / "File Types" tab. The "open" command is shown as a valid command for this association. The problem: When I'm in Windows Explorer and try to open a file that has the associated file ex...

Average of Averages
Another seemingly simple process which I can't figure. :) I have a list of averages, and I want to get the average of them. As such, A 1 25% 2 42% 3 100% 4 50% I need a formula to average something like the above. Thanks, Alan =AVERAGE(A1:A4) is one possible solution. Hope it helps. -- goober ------------------------------------------------------------------------ goober's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19838 View this thread: http://www.excelforum.com/showthread.php?threadid=513937 Hi Alan It really depen...

Need to extract XML or SGML entities from a Unicode text
I'm working on a list of japaneese entities that contain the entity, the unicode hexadecimal code and the xml/sgml entity used for that entity. A unicode document is read into the program, then the program sorts out every doublet and the hexadecimal unicode code is extracted, but I dont know a way to find the xml or sgml-entity equivalent to the unicode code. Anyone who could give me a pointer? Best regards Frantic wrote: > I'm working on a list of japaneese entities that contain the entity, > the unicode hexadecimal code and the xml/sgml entity used for that > entity. ...

2 data files with same address....
When looking at the acct. settings for my data files, I noticed I have two Personal Folders showing, each with the the file name: Outlook.pst\Documents and Settings\Lenovo User\Desktop\Company Name. One is marked default. When I click on the "open folder" button, I get the same file in the above referenced folder on my desktop. Why would I have two and should one be deleted? BTW, I use OL2007 and Win XP Pro SP 3. Thanks- asf66 This would indicate a corruption in your mail profile. You can recreate it via the Mail applet in Control Panel. See http://www.how...

Excel view backwards
I have an user running Office 2000 and when she starts a new workbook her view opens up backwards ie the row were it says A-ZZ that is usually left to right is right to left and her column numbers that mark each column are on the right side instead of left side, Anythoughts. I have looked for the template that the new workbook access but cannot find it in the tree to replace the template. any help is appreciated Christine Hi! Goto Tools>Options>International tab>Right-to-left Biff "Christine" <Christine@discussions.microsoft.com> wrote in message news:CCC879...

Cursor position doesn't stay put when revealing hidden text
Word 2003--In a long document with lots of hidden text that codes many table of authorities entries, when you press "show hidden" the placement of the cursor stays at the same position on the page instead of staying with the word I left it on. How can I make the cursor stay where I left it? -- Janet N.--Legal Sec''y Appellate Specialist ...

opening files
Hi - I am trying to find a setting that will enable the file browser to autocomplete the file path when you are trying to open a file. my hard drive crashed so all my previous settings were blown away. It used to be that when I started opening a file, if I started typing in the browser window, the file path would auto complete. for example, if I were going to "c:\my documents", as soon as I typed "c:\my" then the rest of the c:\my documents string would appear in the browser would appear automatically. Does anyone know how to enable this feature? It u...

Excel Autofilter Copy and Paste with Changing Values
I have used a macro written by Ron de Bruin entitled “Copy5” that uses Autofilter to find, copy, and paste rows from one worksheet to another. My search criteria are called out as follows: My_Range.AutoFilter Field:=2, Criteria1:="=" & Worksheets("Calculations").Range("A16").Value My_Range.AutoFilter Field:=3, Criteria1:="=" & Worksheets("InputPage").Range("A13").Value My_Range.AutoFilter Field:=4, Criteria1:="=" & Worksheets("InputPage").Range("B2").Value My_Range.AutoFilter ...

Outlook 2003 Exchange Caching
Anyone know where the exchange cache file is created on the outlook 2003 client machine? It's an OST file. Search for that. You may need to enable showing hidden and system folders to be able to see the file in Windows Explorer. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginners Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm <anonymous@discussions.microsoft.com> wrote in message news:014501c3aed3$eb8a7cc0$a501280a@phx.gbl... > Anyone know where the exchange ...

averaging less than values
How do I average a column of numbers where less than values are calculated as that number? 2 <2 3 4 <2 5 In the average I want the<2 to = 2. So the answer should be 3 -- JD Assuming source data as posted in A2:A7 Paste this in say, B2, then press CTRL+SHIFT+ENTER to array-enter the formula: =AVERAGE(SUBSTITUTE(A2:A7,"<","")+0) Adapt the ranges to suit -- Max Singapore http://savefile.com/projects/236895 Downloads:17,500 Files:358 Subscribers:55 xdemechanik --- "JD" wrote: > How do I average ...

How to open publisher 95 file in publisher 98
I have Publisher 98. I was given a file to work on that was created in Publisher 95. I cannot open it, I don't understand why newer version files cannot open older ones. Is there any help out there? Are you using Norton anti-virus by any chance? -- JoAnn Paules MVP Microsoft [Publisher] "westpix" <westpix@discussions.microsoft.com> wrote in message news:D217BA64-404D-4CDB-BE5D-64A25A8FF8C5@microsoft.com... >I have Publisher 98. I was given a file to work on that was created in > Publisher 95. > I cannot open it, I don't understand why newer version fi...

insert a JPEG into EXCEL 2002
Hello - I was asked to "pretty up" an Excel invoice for work and need to place a JPEG into the file. I know I can't insert a picture into the header/footer with Excel 2002, but can't I just insert it into the body of the file? In Excel Help it simply says to click on Insert Picture, but for some reason the Insert Picture option is ALWAYS greyed out. Any suggestions? I would REALLY appreciate it! Cheers! Hi mckee You can insert a picture into the header / footer with XL 2002. Go to File>PageSetup. Select the "Headers / Footers" tab and select "Custom ...

greyed out files
I have just transfered files from an old imac to a new powerbool (office = 98 to=20 office 2004), The flles on the new computer are "greyed out". any ideas? Tom wrote : > I have just transfered files from an old imac to a new powerbool (office 98 to > office 2004), The flles on the new computer are "greyed out". any ideas? Did you use a MS DOS formatted disk to do the transfer? Or through an email software that puts files in a Windows format? This could be the reason (I did the same), as the "Creator" and "Type" of your files seem to have been l...

.PST File won't decrease in size
1. I had over two years worth of e-mail in my PST file that made the file size aproximately 850 MEGS. 2. I needed to shrink file size. 3. So I deleted in Outlook ALL MESSAGES and only left contacts. This should have decreased the file size of the PST file. However it has not. 4. What can I do now to decrease the file size of the PST file? Hi Frank, Reduce the size of a data file ------------------------------------------------ A data file is a Personal Folders file (.pst) (Personal Folders file (.pst): Data file that stores your messages and other items on your computer. You ca...

IF=text then go to...
Hi, I've this trouble... I want that if cell A1 value of sheet1 is equal to one word (example X) then go to cell A2 of sheet2. Is it possible? TIA Formulas don't do the "goto" stuff. They retrieve values from other locations. That's about it. testing wrote: > > Hi, > I've this trouble... > > I want that if cell A1 value of sheet1 is equal to one word (example X) then > go to cell A2 of sheet2. > > Is it possible? > > TIA -- Dave Peterson No, there is no formula that will do this -- Bernard V Liengme Microsoft Excel MVP...

Scanning issues
We receive items on purchase orders by scanning our vendors UPCs. When we do this, we have one person do the UPC scanning and another person watching the computer screen to make sure each item goes in okay. Not the most efficient system. Is there anything we can do to have the computer give some sort of audible warning if the UPC isn't recognized or the item wasn't on the purchase order? -- Kris not a total solution but scanners can be programmed to allow only certain types of barcodes. this may help. not sure about the pc end because I don't use rms. "Kris"...

Insert a file path as a hyperlink
Is there a way to browse and select the file path and insert it as a hyperlink like in Outlook 2000? Like, in what application? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Brooke asked: | Is there a way to browse and select the file path and | insert it as a hyperlink like in Outlook 2000? First, you have to select HTML from the Format menu. Then, type or past...

Averages
Hello again, I have an interesting situation. I basically inherited an older database that is used to enter dates, usage and charges for accounts. The situation is that we are attempting to do averages filtered by account, and averaged against the number of days that data has been entered. So, for example, we had 7 months of data entered, our query should total the number of days in the seven months (x), then average that with the total usage number (y). This data currently resides in the same table labeled "data" in the form of from and to dates (6/1/1999 to 7/1/1999) and usage (32...

Exchange 2003 and Win2003 problems with mailboxes
I installed Windows Server 2003 and Exchange 2003 2 weeks ago. After the install Internet email would not come through, I fixed that problem but after the fix there are 6 emails in the server that keep downloading into the mailboxes. you can delete all of the new emails that show up but they start downloading again and again. It seems as if the email never leaves the server. I have checked all of the Outlook setting and it is to remove the mail from the server (not leaving it on the server for X days). When I go into OWA you cannot delete the emails at all but they only download once. If...

According to posts on this newsgroup... importing a .pst file is a 'no no'
What about the Files & Settings Transfer Wizard? Will this method corrupt a ..pst file? Got xp home on a slave drive. Got xp pro freshly installed on a master and I want to get outlook over FROM xp home on the slave. Same copy/version of outlook on both drives.... slave will be formatted once all is tested. Thanks. Importing is bad but the FASTW is not an import. It simply places items where your programs will likely find them, such as your .pst file, among other attributes (like accounts settings transfer, etc.) -- Milly Staples [MVP - Outlook] Post all replies to the group to ...

Removing shadowed Text boxes
I'm using Excel 97 to revise a document which contains shadowed text boxes that I can't select. They span across cells and aren't aligned to them. I've unprotected the workbook and sheet but I still can't select them to get properties, or to modify. Can someone help identify what they may be and/ or how to revise/ delete them Thank you in advance. nr, Don't know if I've seen this one. Try holding Ctrl, as you try to select it. Or try turning on the Drawing Selection tool (a arrow toward the left of the Drawing toolbar). Be sure to turn it back off when you'...

How can set to default the Format Text with No Spacing in Word / Outlook 2007?
I am using Office 2007 package, including Word 2007 and Outlook 2007. I have noticed that when I open a new document (or email) my Word always deafults to "Normal" in Format Text, which means that there is a one-line space in between each line that I write text in Word or Outlook. How can I set that both Outlook and Word always deafults to "No Spacing" between the lines of text. I assume that whateevr setting I have in Word are automatically used by Outlook when I open a new email or select reply to one? Please advise! Michael B. <mystic02removethisplease@ver...

OWA Front-End Server Issues
I have setup a front-end OWA server to allow remote users to read their mail remotely (obviously). The problem I encountere is as follows; the OWA is on a DMZ and can be accessed from the internal network. When connecting to the OWA server from the outside (public ip) I cannot even connect to the site. Here is what our network looks like: Internet | ***Router*** |_____DMZ-----OWA Front-End (Using NAT IP 208.xxx.xxx.xxx ext/192.168.xxx.xxx int) | Other Web Servers ***Firewall*** | Internal Network (Win2k3) 1 Exchange2k3 Ent. Server 2...