Running Office 2001 on Mac OS 10.2, help
This might be a dumb question, but I don't want to screw things up. I was running Mac OS 9.0.4 and I downloaded OS 9.1, 9.1.2, 9.2.2 and then the new 10.2. However, all my software is still in the 9.1 classic. I want to use it all in the new OS 10.2. Will Office 2001 Academic Edition work in OS 10.2? Do I need to uninstall it in OS 9.1 first, then install it is OS 10.2? Or, can I just drag and drop it on the 10.2 desktop or in the applications folder? I have a lot of other expensive softwares in OS 9.1 that I don't want to have to upgrade, but need to be able to use in OS 10.2. Will they work in the new operating system too? They are mostly Adobe stuff like Photoshop 6.0, Quark 4.1, Illustrator 9.0, Freehand 9.0, and Pagemaker 6.5 plus. Also, what's the most effective/best method to unistall cleanly, if I have to. Thank you so much for your help. Stacey
staceys2nd
mac.office
7017 articles. 
0 followers.
3 Replies
676 Views
On 10/18/03 9:01 PM, in article 1dcb0c1d.0310182001.60a7f8eb@posting.google.com, "Stacey" <staceys2nd@aol.com> wrote: > This might be a dumb question, but I don't want to screw things up. I > was running Mac OS 9.0.4 and I downloaded OS 9.1, 9.1.2, 9.2.2 and > then the new 10.2. However, all my software is still in the 9.1 > classic. I want to use it all in the new OS 10.2. Will Office 2001 > Academic Edition work in OS 10.2? Do I need to uninstall it in OS 9.1 > first, then install it is OS 10.2? Or, can I just drag and drop it on > the 10.2 desktop or in the applications folder? > > I have a lot of other expensive softwares in OS 9.1 that I don't want > to have to upgrade, but need to be able to use in OS 10.2. Will they > work in the new operating system too? They are mostly Adobe stuff > like Photoshop 6.0, Quark 4.1, Illustrator 9.0, Freehand 9.0, and > Pagemaker 6.5 plus. None of these apps get installed "in" an operating system. They get installed on a computer. If you're still on the same computer - and it definitely sounds as if you are - you don't have to install anything. They're already there. You just start them up, and "Classic" opens to accommodate them. With so many classic apps, you'll probably want to keep Classic open all the time and have it open at startup. You can make those settings in System Preferences (in the Dock) - Classic. If you want to - you don't have to. Entourage is a special case in OS 10.2. The Microsoft User Data folder, which was in the root Documents folder on your hard disk for OS 9, needs to be in you "user" Documents folder for OS 10.. That's Hard Disk/Users/[username]/Documents So move it there and delete it from the root Documents folder on your HD. If you might sometimes be booting into OS 9, you can make an alias of the Microsoft User Data folder (option-command-drag from new location to old) back in the root Documents folder after you delete the real folder from there. Now you'll be able to reach your identity for mail, contacts, calendar, etc. from either location. > > Also, what's the most effective/best method to unistall cleanly, if I > have to. Thank you so much for your help. You don't need to, now but if you should ever have to, get the "Remove Office 98 and 2001 Tools" application from the MacTopia website <http://www.microsoft.com/mac/downloads.aspx#Office2001> -- Paul Berkowitz MVP Entourage Entourage FAQ Page: http://www.entourage.mvps.org/toc.html Please "Reply To Newsgroup" to reply to this message. Emails will be ignored. PLEASE always state which version of Entourage you are using - 2001 or X. It's often impossible to answer your questions otherwise.
spoof_berkowitOn 10/18/03 21:01, in article 1dcb0c1d.0310182001.60a7f8eb@posting.google.com, "Stacey" <staceys2nd@aol.com> wrote: > This might be a dumb question, but I don't want to screw things up. I > was running Mac OS 9.0.4 and I downloaded OS 9.1, 9.1.2, 9.2.2 and > then the new 10.2. However, all my software is still in the 9.1 > classic. I want to use it all in the new OS 10.2. Will Office 2001 > Academic Edition work in OS 10.2? Do I need to uninstall it in OS 9.1 > first, then install it is OS 10.2? Or, can I just drag and drop it on > the 10.2 desktop or in the applications folder? > > I have a lot of other expensive softwares in OS 9.1 that I don't want > to have to upgrade, but need to be able to use in OS 10.2. Will they > work in the new operating system too? They are mostly Adobe stuff > like Photoshop 6.0, Quark 4.1, Illustrator 9.0, Freehand 9.0, and > Pagemaker 6.5 plus. > > Also, what's the most effective/best method to unistall cleanly, if I > have to. Thank you so much for your help. > Stacey Stacey, You need Office V.x if you want it to natively run under OS X. If you install Office 2001, OS X will call OS 9 to run it. So, in answer to your question, it will run under 10.2.x but will run in an OS 9 window. You should be able to run most of your software in OS X just fine. If you need to uninstall, check each program first for an uninstall application. Virtually all OS X apps can be uninstalled just by throwing it's package away and then emptying the trash. The drag-uninstall may not be perfect either since some files might be left behind. Best to read the documentation carefully for each app. Good luck... Wayne LT Wayne J. Kulick Space Systems Engineering Naval Postgraduate School
wjkulickIn article <BBB87D78.169F%wjkulick@nps.navy.mil>,
LT Wayne Kulick <wjkulick@nps.navy.mil> wrote:
> Virtually all OS X apps can be uninstalled just by throwing it's package
> away and then emptying the trash. The drag-uninstall may not be perfect
> either since some files might be left behind. Best to read the documentation
> carefully for each app.
Office apps are good examples of apps that should not be uninstalled
by dragging them to the Trash. Hidden or other files that aren't
removed that way can be detrimental when the apps are reinstalled.
For Office 98/2001, use the Remove Office apps found at
Mactopia downloads:
http://www.microsoft.com/mac/download/default.asp
For Office v.X, use the Remove Office application found in the Value
Pack folder on the install CD.
jemcgimpsey
Similar Artilces:
Excel 2007
When I select cells to copy as a picture in Excel 2007, the resolution is terrible. Text and objects with shadow's are very blotchy when pasting the picture. How do you change the resolution of a 'Copy Picture'? ...
upgrade from mac office to pc?
Can you upgrade from Office 2004 for Mac to Office 2007 for PC for the lower upgrade price? Or do I have to basically start over and buy Office again for $250 - $300 or whatever it is, if I switch from Mac and buy a new PC? (I have Office '04 on my iMac. I'm weighing buying either a new iMac or a new Dell. The cost of buying Office again makes the inferior-but- cheaper Dell almost as expensive as a new Mac, alas.) In article <1191937383.931978.3920@y42g2000hsy.googlegroups.com>, "Charles T. Shay" <cshea2@gmail.com> wrote: > Can you upgrade from Office 2004...
worksheet tabs 01-06-10
Hi In the 2003 excel-- Is there a way to have the worksheet tabs automatically go in alphabetical order-- or do you have to do in manually? -- Thank-you! Ruth Ruth, Use this code: Sub ArrangeSheetsInOrder() Dim iCount As Integer Application.ScreenUpdating = False iCount = Sheets.Count For i = 1 To iCount - 1 For j = i + 1 To iCount If Sheets(j).Name < Sheets(i).Name Then Sheets(j).Move Before:=Sheets(i) End If Next j Next i End Sub "Ruth" wrote: > Hi > > In the 2003 excel-- Is there a way to have the worksheet tabs automatically ...
Exchange for remote users/offices
Up to this point i've used SBS 2003 with POP3 (using Popbeamer)...the reason i chose this from the get go was because we have about 15 users here on site and about another 20 that are scattered across the globe. I didn't want to be in charge of mail for those that weren't here remotely, so figured just using the POP3 route was the way to go. Well, i'm preparing to move to SBS 2008 and REALLY want to set it up as a true Exchange server hosing the mail. But, again, am not sure i want to deal with the other 20 users if i don't have to. So, is there a way to set up ...
removing replicated table information from MS Office Access 2003
I have a tool that exports .xml files which are then imported into a table. If I import the file without any replicated information (ie. s_ColLineage, etc) how would this affect the database? Is it safe to do this? Would I be better off just making the tables not replicable? Thanks On Tue, 4 Mar 2008 03:33:07 -0800, DukeJon <DukeJon@discussions.microsoft.com> wrote: Assuming your Access database does not need replicating, yes, it is safe to omit those fields during import. -Tom. >I have a tool that exports .xml files which are then imported into a table. >If I import the f...
Standalone install of Office 98 Upgrade?
I'm in the process of getting an old Mac up and running on OS 9 for my teenager. I want to install Office 98, but my version, in the box, is Upgrade. I can't find any earlier Office software around here. Does anybody know if I can install the Upgrade version as a standalone, or must I find an earlier version somewhere? Thanks. On 9/13/05 2:11 PM, in article 1126645896.323979.65210@z14g2000cwz.googlegroups.com, "violetcrumble" <sh@centurytel.net> wrote: > I'm in the process of getting an old Mac up and running on OS 9 for my > teenager. I want to install Off...
Lookup based on criteria in 2 columns
Hi, I am trying to use a vlookup or other function to return the value in the amount column based on the location and date. Here is a sample of my data: Location Date Amount 101 9/15/8 10 101 9/16/8 20 101 9/17/8 15 102 9/15/8 50 102 9/16/8 75 102 9/17/8 67 For example if I wanted to return the amount for location 102 on 9/15/8, what formula would I use? I tried using variations of vlookups but had no luck. Thanks, =SUMPRODUCT(--(A2:A50=102),--(B2:B50=DATE(2008,9,15)),C2:C50) -- Regards, Peo Sjo...
Running average
Hi Guys, Been struggling a bit on this so a pointer would be great. Just a simple example would do.. tableA with two fields "Startdate" and "Amount" now i need a running average in the query which would give me the following output: [Startdate] - [amount] - [average] 1-1-2010 - 100 - 100 2-1-2010 - 50 - 75 3-1-2010 - 60 - 70 So in the average column the last value should be the average of the sum of the previous records and the current records (being the average of the total). I know that the fieldnames are...
Rollup 2 and Office 2007
I already have Roll Up 1 and the Office 2007 compatibility patch installed. If I now install roll up 2 will I have to reinstall the office 2007 compatibility? yes -- Regards, MS CRM Certified Professional http://microsoftcrm3.blogspot.com Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexpert@gmail.com "LLoyd" wrote: > I already have Roll Up 1 and the Office 2007 compatibility patch installed. > If I now install roll up 2 will I have to reinstall the office 2007 > compatibility? ...
Outlook 2003 keeps crashing #2
I get this message when I look in System information. Outlook keeps crashing quite often. I cannot for example delete two messages without outlook crashing. My colleagues do not have this problem. We are using the Microsoft mail exhange server. Faulting application outlook.exe, version 11.0.5510.0, stamp 3f1380f0, faulting module mso.dll, version 11.0.5606.0, stamp 3f334cce, debug? 0, fault address 0x003b6e16. Does anyone has a solution?=20 Best regards/ Bj=F6rn 1) I would definitely apply Service Pack 2for Office 2003 + applicable critical security updates. 2) Have you tried starting O...
Microsoft POS #2
I have a group of customers that I am working on setting up A bundled POS system for. I have looked at RMS and Microsoft POS. The customer's are small bulk food stores. They package all of the bulk food in various containers and weigh it with a Hobart scale producing a label with an system 2 price enbedded barcode. These are UPC A formats. They are for the most part simple single store installs and donot require the complex RMS system. I have setup the Microsoft POS version 2.0 and found it will work perfect for these customers. The only problem when you programed the system you l...
Help with income/expenses
Running 2003 in home page I setup income and expenses I prefer to see one whole month. Money some how shows it as 1/22/2006 through 2/20/2006 any way to fix this? Thanks Jeff ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- ...
help with simple maths in excel
I want to do a simple arithmatic excercise in excel for my grand daughter. It is stuff like 2+2 =4 Smart me has hit a problem at the first hurdle... I need to put 2 in one cell the + in another cell and then 2 in another = in another and then she puts the answer in the next one. So the above would have 4 cells completed and she would put the answer in the 5th one. When I use the + or = sign in a cell of its own it (excel) thinks I am doing an equation, is there a way around this? I will work on the answer like if she gets it correct or wrong how I will do that...a sound or som...
HELP! Need to export hourly sales data on POS (NOT RMS)
How can I export hourly sales data across a date range? For instance, I want to show hourly sales for the month of October so I can graph it and post it in our break room. If I can't export hourly data, can I export daily sales? The built-in reports don't address this data format. This is a multi-part message in MIME format. ------=_NextPart_000_008E_01C826DC.CBC512D0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit Mark, This should work for you. Keep in mind it takes up to 5-10 minutes to load...
Need help with Auto Filter
I have a spreedsheet that is filtered in multiple columns. I am running a "Subtotal" function to count certian rows when I filter the column. My question is this. Is there a way to save or freeze the data that the subtotal function counts in a different cell. In other words I want subtotal to count everything in a particular column but I want to be able to save that number somewhere so that when I filter again with another variable I am able to still view the first subtotal to compare the two. I hope this makes sense and thanks in advance for any assistance you can provi...
Help with a simple database
I am attempting to use Excel to develop a simple database for my office. The database basically lists a variety of orders purchased from various vendors, and my goal is to categorize and sort each vendor seperately. For example: GC Group 4/24/03 7831.1 $1,000.00 Alpha 1/20/03 7003.1 $2,000.00 Chandler 5/6/03 7050.1 $345.50 Is what the main chart looks like. Now, what I'm trying to accomplish is, suppose I added Tomsen 4/20/03 7873.1 $200.00 to the very bottom, Excel would automatically create a new tab (or even worksheet, if possible) tit...
HELP! remote data not accessible msg
Hello, I have a use who is currently using a Bloomberg DDE add- in. Whenever he attempts to activate the add-in to retreive remote data, the system hangs. If I go to task manager, I then see a message stating "Remote data not accessible. To access this data Excel needs to open another program.... I have searched the knowledge base and didn't find much help. Does anyone have any ideas? I am desperate!!!! We are currently using Excel 2003 in XP Professional. TIA, Ramissah ...
Looking for help on timing within a function
At the facility I work, our associates use a very basic access database to sign out individual work orders on an interval of around every 12 minutes. They have asked if it would be possible to put a timer on the front page of the database to show how long they have been working on the current work order, updating each time they sing out another order. I am not very adept at access nor is the rest of our management staff. Is it possible to add this function, so they can better keep time of their work being done? Use the Form Timer event. Here is an example of how it can be done. In this ex...
Can anyone help ?
I have created a holiday planner for staff with in are company and i need a formula that gives us only 10% of the total number of staff are off on holiday. would be greatful if anyone could help. Hello - If you have a total somewhere (I would suggest inserting a column on your spreadsheet titled Total and then entering a "1" if the person is going to be out, then total the column of "1"s by entering "=SUM(x:y)" where x=first cell in the range, and y=last cell in the range), in a different cell, enter "=.1*z" where z equals the total of people out...
Office 2003, Outlook (Outlook Today)...
OK, this is driving me nuts. I note that w' 2003 (and XP (2002)?) the default install sets the startup folder to the Inbox. IIRC, one of the earlier Offices installed Outlook to startup w' that "all in one view" - Outlook Today. So just as a wee test - I thought I'd try that for a while, and indeed I found it quite handy to be able to see all pertinent data on the one screen. *However* (and I'm wondering if this is the case with others), I *HAVE* to use my mouse, whenever I switch to the Inbox, or Calendar, or Tasks to get the damn focus onto a 'sujbect&...
matching contents #2
E1 thru E10 contains sequentially-sorted data. B1 thru B6 contains sequentially-sorted data which matches SOME (but not ALL) of the data in Col A. For example. B E 1 1 1 2 3 2 3 4 3 4 5 4 5 6 5 6 10 6 7 7 8 8 9 9 10 10 I need to move the data in the cells in Col B next to the cells in Col E that have the same contents. For example: B E 1 1 1 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 8 8 9 9 10 10 10 Besides dr...
Please ignore #2
Testing a posting problem -- Jim Bunton ...
Need Query Help
I have two tables, Table A & Table B, in my database that have the same fields (Name, SSN, etc). Most of the records in both tables are identical, but each table has some unique records. I would like to run a query that will select the unique records in Table A by comparing SSNs, and then do the same for Table B. I am a database novice, and have tried all the wizards and expression builders with no luck. Any help at all would be appreciated. Thank you!!! Scott Casa Grande, AZ Hi Scott, The "Find Unmatched Query Wizard" is what you need. If you only want to check for SSNs ...
2 register ruinning together on one z report
Is this possible, to have two registers running on one z report ? We have a small store and would like to setup a second register as a backup, temporary addition ( during rush hours) Since we are a small show i do not need to have a separate register reports. Can two registers ring up all sales together as one ? How can i set this up ? No, you can't do that. You might be able to use the Register Analysis report available in SO Manager Utilities/Crystal Reports to get something close to a single Z though. Glenn Adams Tiber Creek Consulting http://www.tibercreek.com glenn@tibercreek.c...
Excel Problem
I have a 23.8 meg excel 2000 spreadsheet set for manual calculation saved to my local hard drive. Every time I try to open it, it takes forver and sometimes never opens but I do not get any error messages, let me just tell you that I am running a P4, 1 GB memory, Office 2K with SP3, and nothing else running when I try to open it. As I said it is set for manual calculation, and it is cleared to not auto calculate when opening or closing. Any idea's as to why this is happening? -- Todd I don't know why you're having this problem but I would like to point something out for w...
When I select cells to copy as a picture in Excel 2007, the resolution is terrible. Text and objects with shadow's are very blotchy when pasting the picture. How do you change the resolution of a 'Copy Picture'? ...
upgrade from mac office to pc?
Can you upgrade from Office 2004 for Mac to Office 2007 for PC for the lower upgrade price? Or do I have to basically start over and buy Office again for $250 - $300 or whatever it is, if I switch from Mac and buy a new PC? (I have Office '04 on my iMac. I'm weighing buying either a new iMac or a new Dell. The cost of buying Office again makes the inferior-but- cheaper Dell almost as expensive as a new Mac, alas.) In article <1191937383.931978.3920@y42g2000hsy.googlegroups.com>, "Charles T. Shay" <cshea2@gmail.com> wrote: > Can you upgrade from Office 2004...
worksheet tabs 01-06-10
Hi In the 2003 excel-- Is there a way to have the worksheet tabs automatically go in alphabetical order-- or do you have to do in manually? -- Thank-you! Ruth Ruth, Use this code: Sub ArrangeSheetsInOrder() Dim iCount As Integer Application.ScreenUpdating = False iCount = Sheets.Count For i = 1 To iCount - 1 For j = i + 1 To iCount If Sheets(j).Name < Sheets(i).Name Then Sheets(j).Move Before:=Sheets(i) End If Next j Next i End Sub "Ruth" wrote: > Hi > > In the 2003 excel-- Is there a way to have the worksheet tabs automatically ...
Exchange for remote users/offices
Up to this point i've used SBS 2003 with POP3 (using Popbeamer)...the reason i chose this from the get go was because we have about 15 users here on site and about another 20 that are scattered across the globe. I didn't want to be in charge of mail for those that weren't here remotely, so figured just using the POP3 route was the way to go. Well, i'm preparing to move to SBS 2008 and REALLY want to set it up as a true Exchange server hosing the mail. But, again, am not sure i want to deal with the other 20 users if i don't have to. So, is there a way to set up ...
removing replicated table information from MS Office Access 2003
I have a tool that exports .xml files which are then imported into a table. If I import the file without any replicated information (ie. s_ColLineage, etc) how would this affect the database? Is it safe to do this? Would I be better off just making the tables not replicable? Thanks On Tue, 4 Mar 2008 03:33:07 -0800, DukeJon <DukeJon@discussions.microsoft.com> wrote: Assuming your Access database does not need replicating, yes, it is safe to omit those fields during import. -Tom. >I have a tool that exports .xml files which are then imported into a table. >If I import the f...
Standalone install of Office 98 Upgrade?
I'm in the process of getting an old Mac up and running on OS 9 for my teenager. I want to install Office 98, but my version, in the box, is Upgrade. I can't find any earlier Office software around here. Does anybody know if I can install the Upgrade version as a standalone, or must I find an earlier version somewhere? Thanks. On 9/13/05 2:11 PM, in article 1126645896.323979.65210@z14g2000cwz.googlegroups.com, "violetcrumble" <sh@centurytel.net> wrote: > I'm in the process of getting an old Mac up and running on OS 9 for my > teenager. I want to install Off...
Lookup based on criteria in 2 columns
Hi, I am trying to use a vlookup or other function to return the value in the amount column based on the location and date. Here is a sample of my data: Location Date Amount 101 9/15/8 10 101 9/16/8 20 101 9/17/8 15 102 9/15/8 50 102 9/16/8 75 102 9/17/8 67 For example if I wanted to return the amount for location 102 on 9/15/8, what formula would I use? I tried using variations of vlookups but had no luck. Thanks, =SUMPRODUCT(--(A2:A50=102),--(B2:B50=DATE(2008,9,15)),C2:C50) -- Regards, Peo Sjo...
Running average
Hi Guys, Been struggling a bit on this so a pointer would be great. Just a simple example would do.. tableA with two fields "Startdate" and "Amount" now i need a running average in the query which would give me the following output: [Startdate] - [amount] - [average] 1-1-2010 - 100 - 100 2-1-2010 - 50 - 75 3-1-2010 - 60 - 70 So in the average column the last value should be the average of the sum of the previous records and the current records (being the average of the total). I know that the fieldnames are...
Rollup 2 and Office 2007
I already have Roll Up 1 and the Office 2007 compatibility patch installed. If I now install roll up 2 will I have to reinstall the office 2007 compatibility? yes -- Regards, MS CRM Certified Professional http://microsoftcrm3.blogspot.com Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexpert@gmail.com "LLoyd" wrote: > I already have Roll Up 1 and the Office 2007 compatibility patch installed. > If I now install roll up 2 will I have to reinstall the office 2007 > compatibility? ...
Outlook 2003 keeps crashing #2
I get this message when I look in System information. Outlook keeps crashing quite often. I cannot for example delete two messages without outlook crashing. My colleagues do not have this problem. We are using the Microsoft mail exhange server. Faulting application outlook.exe, version 11.0.5510.0, stamp 3f1380f0, faulting module mso.dll, version 11.0.5606.0, stamp 3f334cce, debug? 0, fault address 0x003b6e16. Does anyone has a solution?=20 Best regards/ Bj=F6rn 1) I would definitely apply Service Pack 2for Office 2003 + applicable critical security updates. 2) Have you tried starting O...
Microsoft POS #2
I have a group of customers that I am working on setting up A bundled POS system for. I have looked at RMS and Microsoft POS. The customer's are small bulk food stores. They package all of the bulk food in various containers and weigh it with a Hobart scale producing a label with an system 2 price enbedded barcode. These are UPC A formats. They are for the most part simple single store installs and donot require the complex RMS system. I have setup the Microsoft POS version 2.0 and found it will work perfect for these customers. The only problem when you programed the system you l...
Help with income/expenses
Running 2003 in home page I setup income and expenses I prefer to see one whole month. Money some how shows it as 1/22/2006 through 2/20/2006 any way to fix this? Thanks Jeff ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- ...
help with simple maths in excel
I want to do a simple arithmatic excercise in excel for my grand daughter. It is stuff like 2+2 =4 Smart me has hit a problem at the first hurdle... I need to put 2 in one cell the + in another cell and then 2 in another = in another and then she puts the answer in the next one. So the above would have 4 cells completed and she would put the answer in the 5th one. When I use the + or = sign in a cell of its own it (excel) thinks I am doing an equation, is there a way around this? I will work on the answer like if she gets it correct or wrong how I will do that...a sound or som...
HELP! Need to export hourly sales data on POS (NOT RMS)
How can I export hourly sales data across a date range? For instance, I want to show hourly sales for the month of October so I can graph it and post it in our break room. If I can't export hourly data, can I export daily sales? The built-in reports don't address this data format. This is a multi-part message in MIME format. ------=_NextPart_000_008E_01C826DC.CBC512D0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit Mark, This should work for you. Keep in mind it takes up to 5-10 minutes to load...
Need help with Auto Filter
I have a spreedsheet that is filtered in multiple columns. I am running a "Subtotal" function to count certian rows when I filter the column. My question is this. Is there a way to save or freeze the data that the subtotal function counts in a different cell. In other words I want subtotal to count everything in a particular column but I want to be able to save that number somewhere so that when I filter again with another variable I am able to still view the first subtotal to compare the two. I hope this makes sense and thanks in advance for any assistance you can provi...
Help with a simple database
I am attempting to use Excel to develop a simple database for my office. The database basically lists a variety of orders purchased from various vendors, and my goal is to categorize and sort each vendor seperately. For example: GC Group 4/24/03 7831.1 $1,000.00 Alpha 1/20/03 7003.1 $2,000.00 Chandler 5/6/03 7050.1 $345.50 Is what the main chart looks like. Now, what I'm trying to accomplish is, suppose I added Tomsen 4/20/03 7873.1 $200.00 to the very bottom, Excel would automatically create a new tab (or even worksheet, if possible) tit...
HELP! remote data not accessible msg
Hello, I have a use who is currently using a Bloomberg DDE add- in. Whenever he attempts to activate the add-in to retreive remote data, the system hangs. If I go to task manager, I then see a message stating "Remote data not accessible. To access this data Excel needs to open another program.... I have searched the knowledge base and didn't find much help. Does anyone have any ideas? I am desperate!!!! We are currently using Excel 2003 in XP Professional. TIA, Ramissah ...
Looking for help on timing within a function
At the facility I work, our associates use a very basic access database to sign out individual work orders on an interval of around every 12 minutes. They have asked if it would be possible to put a timer on the front page of the database to show how long they have been working on the current work order, updating each time they sing out another order. I am not very adept at access nor is the rest of our management staff. Is it possible to add this function, so they can better keep time of their work being done? Use the Form Timer event. Here is an example of how it can be done. In this ex...
Can anyone help ?
I have created a holiday planner for staff with in are company and i need a formula that gives us only 10% of the total number of staff are off on holiday. would be greatful if anyone could help. Hello - If you have a total somewhere (I would suggest inserting a column on your spreadsheet titled Total and then entering a "1" if the person is going to be out, then total the column of "1"s by entering "=SUM(x:y)" where x=first cell in the range, and y=last cell in the range), in a different cell, enter "=.1*z" where z equals the total of people out...
Office 2003, Outlook (Outlook Today)...
OK, this is driving me nuts. I note that w' 2003 (and XP (2002)?) the default install sets the startup folder to the Inbox. IIRC, one of the earlier Offices installed Outlook to startup w' that "all in one view" - Outlook Today. So just as a wee test - I thought I'd try that for a while, and indeed I found it quite handy to be able to see all pertinent data on the one screen. *However* (and I'm wondering if this is the case with others), I *HAVE* to use my mouse, whenever I switch to the Inbox, or Calendar, or Tasks to get the damn focus onto a 'sujbect&...
matching contents #2
E1 thru E10 contains sequentially-sorted data. B1 thru B6 contains sequentially-sorted data which matches SOME (but not ALL) of the data in Col A. For example. B E 1 1 1 2 3 2 3 4 3 4 5 4 5 6 5 6 10 6 7 7 8 8 9 9 10 10 I need to move the data in the cells in Col B next to the cells in Col E that have the same contents. For example: B E 1 1 1 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 8 8 9 9 10 10 10 Besides dr...
Please ignore #2
Testing a posting problem -- Jim Bunton ...
Need Query Help
I have two tables, Table A & Table B, in my database that have the same fields (Name, SSN, etc). Most of the records in both tables are identical, but each table has some unique records. I would like to run a query that will select the unique records in Table A by comparing SSNs, and then do the same for Table B. I am a database novice, and have tried all the wizards and expression builders with no luck. Any help at all would be appreciated. Thank you!!! Scott Casa Grande, AZ Hi Scott, The "Find Unmatched Query Wizard" is what you need. If you only want to check for SSNs ...
2 register ruinning together on one z report
Is this possible, to have two registers running on one z report ? We have a small store and would like to setup a second register as a backup, temporary addition ( during rush hours) Since we are a small show i do not need to have a separate register reports. Can two registers ring up all sales together as one ? How can i set this up ? No, you can't do that. You might be able to use the Register Analysis report available in SO Manager Utilities/Crystal Reports to get something close to a single Z though. Glenn Adams Tiber Creek Consulting http://www.tibercreek.com glenn@tibercreek.c...
Excel Problem
I have a 23.8 meg excel 2000 spreadsheet set for manual calculation saved to my local hard drive. Every time I try to open it, it takes forver and sometimes never opens but I do not get any error messages, let me just tell you that I am running a P4, 1 GB memory, Office 2K with SP3, and nothing else running when I try to open it. As I said it is set for manual calculation, and it is cleared to not auto calculate when opening or closing. Any idea's as to why this is happening? -- Todd I don't know why you're having this problem but I would like to point something out for w...