office 2004 (excel & word) afp file path issue on tiger server (10.4.9) #2

g'day,

we have just changed over to an xserve (running 10.4.9, HFS+ with
ACLs) and are experiencing the following problem with office 2004
excel & word files only - surprisingly powerpoint files are not
affected:

all excel and word files without spaces in either file- path or -name
open just fine, however all files with spaces in file-path or -name
generate the following error message...

<img src="http://homepage.mac.com/daniel.schagemann/posts/EXCEL_1.png"
alt="excel error message" />

for the above we used the following example file:
-rwxr--r--   1 daniel  daniel  59904 May 17 16:40 IT Schedules.xls

and it gets slightly more confusing if we place the file used above in
another sharepoint called scans (which is setup in exactly the same
way) the file opens just fine... with or without spaces in its
filepath?

<img src="http://homepage.mac.com/daniel.schagemann/posts/EXCEL_2.png"
alt="excel filepath display" />

we have also noticed that strangely the complete file-path is being
displayed in files that do open (because we have filled in the
blanks... ;0) - something we had not seen before.

any ideas on what could cause this or advice on how we could get back
to opening our mainly excel and word files straight from the server
without having to change our folder structure would be greatly
appreciated.

thanks in advance,

ds.

0
5/17/2007 8:11:17 AM
mac.office 7017 articles. 0 followers. Follow

6 Replies
686 Views

Similar Articles

[PageSpeed] 43

In article <1179389476.823436.293910@q23g2000hsg.googlegroups.com>,
 schagemann@gmail.com wrote:

> we have just changed over to an xserve (running 10.4.9, HFS+ with
> ACLs) and are experiencing the following problem with office 2004
> excel & word files only - surprisingly powerpoint files are not
> affected:
> 
> all excel and word files without spaces in either file- path or -name
> open just fine, however all files with spaces in file-path or -name
> generate the following error message...
> 
> <img src="http://homepage.mac.com/daniel.schagemann/posts/EXCEL_1.png"
> alt="excel error message" />
> 
> for the above we used the following example file:
> -rwxr--r--   1 daniel  daniel  59904 May 17 16:40 IT Schedules.xls
> 
> and it gets slightly more confusing if we place the file used above in
> another sharepoint called scans (which is setup in exactly the same
> way) the file opens just fine... with or without spaces in its
> filepath?
> 
> <img src="http://homepage.mac.com/daniel.schagemann/posts/EXCEL_2.png"
> alt="excel filepath display" />
> 
> we have also noticed that strangely the complete file-path is being
> displayed in files that do open (because we have filled in the
> blanks... ;0) - something we had not seen before.
> 
> any ideas on what could cause this or advice on how we could get back
> to opening our mainly excel and word files straight from the server
> without having to change our folder structure would be greatly
> appreciated.

Very odd problem. Are you connecting to the server via AFP or SMB? I 
would assume AFP since this is an Apple server.

Can you provide an example of one of the problem paths? Preferably, open 
the Terminal application and drag an Excel file from the server into the 
window. This will provide the full path in one long string. (Don't worry 
about the backslash characters before certain characters and spaces. 
These are normal.)

bill
-- 
William M. Smith
(Microsoft Interop MVP - Mac/Windows)
0
mecklists1 (142)
5/18/2007 1:59:03 AM
On May 18, 11:59 am, William Smith <meckli...@REM0VETH1S.comcast.net>
wrote:
> In article <1179389476.823436.293...@q23g2000hsg.googlegroups.com>,
>
>
>
>  schagem...@gmail.com wrote:
> > we have just changed over to an xserve (running 10.4.9, HFS+ with
> > ACLs) and are experiencing the following problem with office 2004
> > excel & word files only - surprisingly powerpoint files are not
> > affected:
>
> > all excel and word files without spaces in either file- path or -name
> > open just fine, however all files with spaces in file-path or -name
> > generate the following error message...
>
> > <img src="http://homepage.mac.com/daniel.schagemann/posts/EXCEL_1.png"
> > alt="excel error message" />
>
> > for the above we used the following example file:
> > -rwxr--r--   1 daniel  daniel  59904 May 17 16:40 IT Schedules.xls
>
> > and it gets slightly more confusing if we place the file used above in
> > another sharepoint called scans (which is setup in exactly the same
> > way) the file opens just fine... with or without spaces in its
> > filepath?
>
> > <img src="http://homepage.mac.com/daniel.schagemann/posts/EXCEL_2.png"
> > alt="excel filepath display" />
>
> > we have also noticed that strangely the complete file-path is being
> > displayed in files that do open (because we have filled in the
> > blanks... ;0) - something we had not seen before.
>
> > any ideas on what could cause this or advice on how we could get back
> > to opening our mainly excel and word files straight from the server
> > without having to change our folder structure would be greatly
> > appreciated.
>
> Very odd problem. Are you connecting to the server via AFP or SMB? I
> would assume AFP since this is an Apple server.
>
> Can you provide an example of one of the problem paths? Preferably, open
> the Terminal application and drag an Excel file from the server into the
> window. This will provide the full path in one long string. (Don't worry
> about the backslash characters before certain characters and spaces.
> These are normal.)
>
> bill
> --
> William M. Smith
> (Microsoft Interop MVP - Mac/Windows)

yes we are using afp to connect - was planning to check the smb part
on the weekend once everyone is gone.

here the filepaths:

working:
/Volumes/file/Administration/IT/Schedules/TEST_without_spaces.xls

not working:
/Volumes/file/Administration/IT/Schedules/TEST\ with\ spaces.xls

exactly the same file with same permissions.

thanks, daniel.

0
5/18/2007 8:08:51 AM
In article <1179475731.776830.59470@w5g2000hsg.googlegroups.com>,
 don't panic <schagemann@gmail.com> wrote:

> yes we are using afp to connect - was planning to check the smb part
> on the weekend once everyone is gone.
> 
> here the filepaths:
> 
> working:
> /Volumes/file/Administration/IT/Schedules/TEST_without_spaces.xls
> 
> not working:
> /Volumes/file/Administration/IT/Schedules/TEST\ with\ spaces.xls
> 
> exactly the same file with same permissions.

Hi daniel!

So "file" is the name of your Mac volume that gets mounted on the user's 
Desktop, correct? I wonder if this is causing the problem. It shouldn't 
but possibly something in the way Office reads files uses some sort of 
"file" denominator.

During your testing this weekend can you change this to "Files" instead 
of "file" and see if this makes a difference? If so then you've found an 
interesting bug that should be reproducible elsewhere.

bill
-- 
William M. Smith
(Microsoft Interop MVP - Mac/Windows)
0
mecklists1 (142)
5/19/2007 3:03:02 AM
Hi Daniel:

I "hope" your file name does not include any slashes, either forward "/" or
back "\" :-)

If it does, that's the problem.  Microsoft Office recognizes the forward and
back slash as equivalent in file names, which enables it to support web
paths in documents.

Cheers


On 18/5/07 6:08 PM, in article
1179475731.776830.59470@w5g2000hsg.googlegroups.com, "don't panic"
<schagemann@gmail.com> wrote:

> On May 18, 11:59 am, William Smith <meckli...@REM0VETH1S.comcast.net>
> wrote:
>> In article <1179389476.823436.293...@q23g2000hsg.googlegroups.com>,
>> 
>> 
>> 
>>  schagem...@gmail.com wrote:
>>> we have just changed over to an xserve (running 10.4.9, HFS+ with
>>> ACLs) and are experiencing the following problem with office 2004
>>> excel & word files only - surprisingly powerpoint files are not
>>> affected:
>> 
>>> all excel and word files without spaces in either file- path or -name
>>> open just fine, however all files with spaces in file-path or -name
>>> generate the following error message...
>> 
>>> <img src="http://homepage.mac.com/daniel.schagemann/posts/EXCEL_1.png"
>>> alt="excel error message" />
>> 
>>> for the above we used the following example file:
>>> -rwxr--r--   1 daniel  daniel  59904 May 17 16:40 IT Schedules.xls
>> 
>>> and it gets slightly more confusing if we place the file used above in
>>> another sharepoint called scans (which is setup in exactly the same
>>> way) the file opens just fine... with or without spaces in its
>>> filepath?
>> 
>>> <img src="http://homepage.mac.com/daniel.schagemann/posts/EXCEL_2.png"
>>> alt="excel filepath display" />
>> 
>>> we have also noticed that strangely the complete file-path is being
>>> displayed in files that do open (because we have filled in the
>>> blanks... ;0) - something we had not seen before.
>> 
>>> any ideas on what could cause this or advice on how we could get back
>>> to opening our mainly excel and word files straight from the server
>>> without having to change our folder structure would be greatly
>>> appreciated.
>> 
>> Very odd problem. Are you connecting to the server via AFP or SMB? I
>> would assume AFP since this is an Apple server.
>> 
>> Can you provide an example of one of the problem paths? Preferably, open
>> the Terminal application and drag an Excel file from the server into the
>> window. This will provide the full path in one long string. (Don't worry
>> about the backslash characters before certain characters and spaces.
>> These are normal.)
>> 
>> bill
>> --
>> William M. Smith
>> (Microsoft Interop MVP - Mac/Windows)
> 
> yes we are using afp to connect - was planning to check the smb part
> on the weekend once everyone is gone.
> 
> here the filepaths:
> 
> working:
> /Volumes/file/Administration/IT/Schedules/TEST_without_spaces.xls
> 
> not working:
> /Volumes/file/Administration/IT/Schedules/TEST\ with\ spaces.xls
> 
> exactly the same file with same permissions.
> 
> thanks, daniel.
> 

-- 
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group.  Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia.  S33�53'34.20 E151�14'54.50
+61 4 1209 1410, mailto:john@mcghie.name

0
john7143 (1072)
5/20/2007 2:20:33 AM
On May 19, 1:03 pm, William Smith <meckli...@REM0VETH1S.comcast.net>
wrote:
> In article <1179475731.776830.59...@w5g2000hsg.googlegroups.com>,
>  don't panic <schagem...@gmail.com> wrote:
>
> > yes we are using afp to connect - was planning to check the smb part
> > on the weekend once everyone is gone.
>
> > here the filepaths:
>
> > working:
> > /Volumes/file/Administration/IT/Schedules/TEST_without_spaces.xls
>
> > not working:
> > /Volumes/file/Administration/IT/Schedules/TEST\ with\ spaces.xls
>
> > exactly the same file with same permissions.
>
> Hi daniel!
>
> So "file" is the name of your Mac volume that gets mounted on the user's
> Desktop, correct? I wonder if this is causing the problem. It shouldn't
> but possibly something in the way Office reads files uses some sort of
> "file" denominator.
>
> During your testing this weekend can you change this to "Files" instead
> of "file" and see if this makes a difference? If so then you've found an
> interesting bug that should be reproducible elsewhere.
>
> bill
> --
> William M. Smith
> (Microsoft Interop MVP - Mac/Windows)

bill

well that did the trick... we simply renamed the sharepoint from
"file" to "files" and it now works as it should.

i suppose we should file an official bugreport about this issue
somewhere?
however, i could not find where to submit such a report - bill, since
you seem somehow affiliated with MS could you please advise on how to
proceed?

anyway, thanks a lot for your help - not sure if we would have thought
about such a simple solution!

daniel.


0
5/21/2007 12:01:18 AM
On May 20, 12:20 pm, John McGhie <j...@mcghie.name> wrote:
> Hi Daniel:
>
> I "hope" your file name does not include any slashes, either forward "/" =
or
> back "\" :-)
>
> If it does, that's the problem.  Microsoft Office recognizes the forward =
and
> back slash as equivalent in file names, which enables it to support web
> paths in documents.
>
> Cheers
>
> On 18/5/07 6:08 PM, in article
> 1179475731.776830.59...@w5g2000hsg.googlegroups.com, "don't panic"
>
>
>
> <schagem...@gmail.com> wrote:
> > On May 18, 11:59 am, William Smith <meckli...@REM0VETH1S.comcast.net>
> > wrote:
> >> In article <1179389476.823436.293...@q23g2000hsg.googlegroups.com>,
>
> >>  schagem...@gmail.com wrote:
> >>> we have just changed over to an xserve (running 10.4.9, HFS+ with
> >>> ACLs) and are experiencing the following problem with office 2004
> >>> excel & word files only - surprisingly powerpoint files are not
> >>> affected:
>
> >>> all excel and word files without spaces in either file- path or -name
> >>> open just fine, however all files with spaces in file-path or -name
> >>> generate the following error message...
>
> >>> <img src=3D"http://homepage.mac.com/daniel.schagemann/posts/EXCEL_1.p=
ng"
> >>> alt=3D"excel error message" />
>
> >>> for the above we used the following example file:
> >>> -rwxr--r--   1 daniel  daniel  59904 May 17 16:40 IT Schedules.xls
>
> >>> and it gets slightly more confusing if we place the file used above in
> >>> another sharepoint called scans (which is setup in exactly the same
> >>> way) the file opens just fine... with or without spaces in its
> >>> filepath?
>
> >>> <img src=3D"http://homepage.mac.com/daniel.schagemann/posts/EXCEL_2.p=
ng"
> >>> alt=3D"excel filepath display" />
>
> >>> we have also noticed that strangely the complete file-path is being
> >>> displayed in files that do open (because we have filled in the
> >>> blanks... ;0) - something we had not seen before.
>
> >>> any ideas on what could cause this or advice on how we could get back
> >>> to opening our mainly excel and word files straight from the server
> >>> without having to change our folder structure would be greatly
> >>> appreciated.
>
> >> Very odd problem. Are you connecting to the server via AFP or SMB? I
> >> would assume AFP since this is an Apple server.
>
> >> Can you provide an example of one of the problem paths? Preferably, op=
en
> >> the Terminal application and drag an Excel file from the server into t=
he
> >> window. This will provide the full path in one long string. (Don't wor=
ry
> >> about the backslash characters before certain characters and spaces.
> >> These are normal.)
>
> >> bill
> >> --
> >> William M. Smith
> >> (Microsoft Interop MVP - Mac/Windows)
>
> > yes we are using afp to connect - was planning to check the smb part
> > on the weekend once everyone is gone.
>
> > here the filepaths:
>
> > working:
> > /Volumes/file/Administration/IT/Schedules/TEST_without_spaces.xls
>
> > not working:
> > /Volumes/file/Administration/IT/Schedules/TEST\ with\ spaces.xls
>
> > exactly the same file with same permissions.
>
> > thanks, daniel.
>
> --
> Don't wait for your answer, click here:http://www.word.mvps.org/
>
> Please reply in the group.  Please do NOT email me unless I ask you to.
>
> John McGhie, Consultant Technical Writer
> McGhie Information Engineering Pty Ltdhttp://jgmcghie.fastmail.com.au/
> Sydney, Australia.  S33=B053'34.20 E151=B014'54.50
> +61 4 1209 1410, mailto:j...@mcghie.name

john,

thanks for your suggestion. and no, we did not use slashes (of either
direction) in our file names - and would dream of doing so. but
definitely a tip worthwile knowing about.

please see my other post for the solution to the problem.

take care, daniel.

0
5/21/2007 12:06:06 AM
Reply:

Similar Artilces:

Word 2010 Beta not responding
I recently bought a Sony Vaio computer with Windows 7 64-bit Home Premium edition. I found Office 2010 Professional online and downloaded the beta version for free until the real one comes out later this year. All of the office suites (Excel, PowerPoint, etc) all work, but when I open up Word, within seconds it freezes up and no matter where I click (even to close it) I get the not responding message and have to close it with task manager. I use Word more than any other application/program on my computer and I love the new Office 2010 and don't want 2007. Does anyone know...

Ingenico i6550 on 2.0.0114
Hi All, I am having a hard time finding any information on installation and configuration of the i6550. Would anyone out there be willing to share their documentation and/or procedures with me? I followed the KB article 935588 but all I get is a blank screen once the device boots. I have gleaned that I need several things to make this work: Form Designer for the device Ingenico OPOS driver newer than 2.4 (?) Better configuration documentation Sample receipt template (?) I would appreciate any detailed documentation that I can get my hands on. Thanks all very much! I installed 7 of th...

onscreen keyboards, focus issues
I know there have been a lot of threads of discussion about people creating onscreen windows, issues about focus changes between edit controls and the onscreen keyboard, etc. I got a question today on this, said "there's been a lot of discussion on the newsgroup". Thought I'd go look for it. Can't find a trace of discussion, even with google. Found one article on www.codeproject.com about building an onscreen keyboard. Anyone remember anything else on this topic, or have pointers I can forward to the party involved? joe Joseph M. Newcomer [MVP] email: newcomer@fl...

sheet tab #2
I want to change font size of sheet 's name. What should I do? thanks ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=46907739-afa1-4f71-aca6-a3a341bef4ec&dg=microsoft.public.exc...

Comparing 2 columns
Column A is full of names (none repeating). Column B has names as well, and the same name MIGHT already be in column A. I want a formula in column C that will first look at cell B1, then search all of Column A, and either answer YES or NO if it is found. I though an If statement would work, but it isnt. I wrote the following - =IF(B1=(A1:A25),"Yes","No") However, this is only returning NO as an answer, even if the name in B1 IS located in the range of A1:A25. Am I doing something wrong, or does this only work for values and not text ? Using Excel 2000, SP2 ly...

Hi I'm New and need help with Excel Basics
Please can anyone help me answer any of these questions: How would you add the contents of the cells from A1 to A10. Give 2 ways to do this. (hint: Look up "Examples of common formulas" in Excel help How do you format a cell to have dollar signs next to the numbers? How do you add the contents of cells A1 through A10 on sheet 1 and make the answer show up on sheet 2? How do you rename a sheet? Can I delete the sheets that I don't need? If so how? How do I freeze rows or columns of the sheet so that they don't' move when you scroll up or down? Example: My n...

File Saving with Text from File
I have a template, and the customer name always goes in the same cell. When I click the save button, I would like to have the customer name pop into the "save as" area instead of having to type it every time. Thanks for your help Only way is to keep opening the same file that already has the customers name. You must be adding dates or numbers after the customers name. Just open up the last file for that customer and tweak the dates/numbers. "jweasl" wrote: > I have a template, and the customer name always goes in the same cell. When I > click the save button, ...

Create Pareto Chart in Excel? #2
Thanks for the responses. The data is in a sorted frequenc distribution. I have the data analysis add-in installed, but i couldn' locate the data analysis pull down or the histogram with pareto option I'm running excel 2000, I can still create a pareto with this versio correct -- Tycon2 ----------------------------------------------------------------------- Tycon22's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1626 View this thread: http://www.excelforum.com/showthread.php?threadid=27698 The bottom entry on the Tools menu should be "Data Analysi...

Excel files won't come up
I am having trouble bringing up any Excel file. I get an error message with a error signature like this AppName:Excel.exe AppVer 9.0.0.2719 ModName:mso9:11 ModVer:9.0.0.2720 Offset:00045909 When I look up the tech information at the bottom I get this c:\docume~1\HarryG~1\Locals~1\temp\2958_appcompat.txt I sent this message last week and the remark was to double click and copy the error and reply. I did and I haven't seen any reply yet. I really need to use the Excel files which I use often. All other ofice files OK Help!!! I don't have a guess about what's ...

How to code a batch file?
Does anyone have any suggestions on how to code a batch file to open an excel file if current time is between 9 am and 10 am? otherwise don't open it. Thanks in advance for any suggestions Eric On Mar 25, 8:37=A0pm, Eric <E...@discussions.microsoft.com> wrote: > Does anyone have any suggestions on how to code a batch file to open an e= xcel > file if current time is between 9 am and 10 am? otherwise don't open it. > Thanks in advance for any suggestions > Eric I would try this group. Andy http://groups.google.com/group/alt.msdos.batch.nt?hl=3Den ...

Can't see 2 open workbooks listed in the Window tab
Using Excel 2003 When I have two workbooks open I think I should see both of the workbooks listed in the Window tab on the Menu Bar. I only see the workbook file I am in. What can I do to correct this? This is not a question on charting, but let's be nice for a change :-) The 'problem' you describe pops up when you open Excel twice, what might happen when you double-click the file from the Explorer to open it while Excel already is open. It will not happen if you have Excel open and open the file from within. HTH, Henk "TomD" wrote: > Using Excel 2003 &...

Outlook 2010 04-19-10
Testing Office 2010 but before using any of the suite need to setup up Outlook first but cannot Import CSV file addressbook from either 2003 or 2007 in to it. Error message "Invalid SAM ID" and following global search it can be done with a "translator" but no one seems to know where to get it from so still cannot use Outlook. Although a beta product Outlook is specifically a communications application but not being able to easily import your contacts makes the application totally useless! I would have thought that MS would have at least made sure that the mos...

rebuild of exchange 5.5 on win2k server
ok, my nt4, exch 5.5, server crashed, setup new win2k server box, installed 5.5, can't do 2k or 2003 exchange yet, no active directory.. only issue is that when installed 5.5 on new box it DOESN'T have SMTP? so inside corporate email works, but not internet email service, which doesn't even show up on the list of services? anyone have any knowledge base article or MAYBE even have had this happen? please SEND HELP... AL In Exch Admin click File\New Other\Internet Mail Service and floow wizard. Al Smith wrote: > ok, my nt4, exch 5.5, server crashed, setup new win2k server...

Outlook damaged PST file
have run the Inbox Repair tool on what Outlook tells me is a damaged PST file. I do not get an option to repair the file. I have moved the file so that it is not available to Outlook but it still appears in the Mail pane as a folder. I can't remove it. I would just like to get rid of it. If I leave the damaged file so that Outlook can access it I also can't remove it since I get a message that elements are missing. Once you've moved the file, you should be able to right-click the entry in the mail pane and select Close. -Peter "DonBob" <DonBob@discussions.micr...

Can't save new Excel Doc
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Help! I have created an excel spreadsheet (with multiple sheets in one doc) but can't save the document. I keep getting an error message that either: <br> - file name or path name does not exist <br> - file is being used by another program <br> - name is the same as another file <br><br>Can anyone tell me why I can't save. (To clarify, none of the &quot;reasons&quot; it won't save are applicable as I have double checked each of those). <br><br>Thanks, <br> Moll...

Bad license file
When signing on I reeive the message "bad license file". I do not know where it came from or how to delete it. Can you help me? -- Thank you, Vista Ray Vista Ray wrote: > When signing on I reeive the message "bad license file". I do not know where > it came from or how to delete it. Can you help me? here as an answer appropriate for your wonderfully vague question https://www.impaticize.com/impkb/questions/218/ To be more specific the message that I receive is Portrait Displays - version changed - bad license file. -- Thank you, Vista ...

Cannot archive old transactions in Money 2004
My money file is very large and I am not able to use the archive function. When I try to archive I get the message, "Money cannot archive your file C:My documents\MoneyFiles\MyMoney.mny." If the file is being used by another application close it in the other application and try again. I have made sure that all other programs are closed when I try to archive. Any ideas? In microsoft.public.money, Marion wrote: >My money file is very large and I am not able to use the >archive function. When I try to archive I get the >message, "Money cannot archive your fil...

how to use collapse/ expand fuction in excel like outlook
...

named excel lists
I'm somewhat of a newbie, so I may not be asking this question with the correct terminology. I'd like to define a name and attach it to the range of an "excel (2003) list". If I add a new row or column to the "excel list", then the range is suitable extended. How? Try Debra Dalgleish's nice coverage of Dynamic Ranges at: http://www.contextures.com/xlNames01.html#Dynamic Look for "Create a Dynamic Range" -- Rgds Max xl 97 --- Please respond, in newsgroup xdemechanik <at>yahoo<dot>com ---- "hidden" <hidden123456@hotmail.com...

formulas #4
You get the best answers if you ask an unambiguous question. What did you do to try to find the answers and what didn't work. "Bj" <bjsmes@aol.com> wrote in message news:18c0701c44b67$499d8070$a101280a@phx.gbl... > ...

hello 03-26-10
thank u for new i hope try to me new see test myself see work it best ok thank u microsoft What are you smoking? "armbreak5" <armbreak5@discussions.microsoft.com> wrote in message news:C747D2F3-AEDA-4241-A6C6-8E795E4A2723@microsoft.com... > thank u for new i hope try to me new see test myself see work it best > ok > thank u microsoft ...

Excel startup with buttons
I was wondering if it is possible to have a blank screen displayed when a user opens up excel, and have them select a button to take them to a particular worksheet in the excel workbook. I have figured out how to use code in visual basic to create the buttons, but when I open the workbook, it displays the "button screen" overtop of whatever the last page was when the workbook was last used. I'd rather not have any of the worksheets visible behind the button choosing screen. Any suggestions? -- alanad ------------------------------------------------------------------------ a...

Ex5.5 Very Slow Restore from Tape #2
One of my users accidentally erased some information from a public folder, so now I have to restore from backup. I have done this before and I don't seem to recall any problems. However this time, the restore seems to be taking forever. I have shut down all the Exchange services and am using ntbackup to restore the public folders file (pub.edb). Right now, the restore has been running for 90 minutes. The Exchange backup is the first thing on this tape. The pub.edb is about 500Mb and the priv.edb is 2Gb. There are also some files from the server's C: drive on this tape. I tried restori...

Terminal Server Setup
Hello, I am trying to setup a terminal server so all Great Plains users have their own Dex.ini file to launch Great Plains. But I am having no luck trying to do this. We are Great Plains 8.0 SP 2 using MS SQL 2000. Does anyone have their system setup this way? Could you give me some advice on what I could be doing wrong? I am following the white paper that is on customersource but following it to a T does not work. I placed the dex.ini file in the windows folder in the local profile of the machine. The local profile did not have a windows folder so I had to create one. I r...

Compacting........or rather not quite.... 02-06-10
MS Windows XP Home Edition Version 5.1 (build 2600.xpsp_sp3_gdr.090804-1435 : service pack 3) copyright 2007 INTERNET EXPLORER Version 7.0.5730.13 Build 75730 I have tried several times over the last couple of months to compact emails in OE. (Usually due to being prompted). Within the box entitled "Compacting" The compacting starts, and zips through the various email folders and then moves onto the newsgroups, (about 8/9 off). With the green progress bar nearly full and showing a "folders file" name tag, a message box explodes on the desk...