Hi Adam, I too was shocked to find this add-in missing. As a Scientist, I rely on this quite a bit for quick and dirty analyses. And did you happen to notice that the error bar functionality for charts has changed?
In Excel 2004 I could specify a custom standard error term (located in the cell of my choice), but this feature is now gone from Excel 2008. What's going on?? Excel 2004 has this. Excel 2007 for Windows has this. Is Microsoft trying to water down Excel to appeal only to average consumers? The analysis tool pack and the ability to specify custom error bars are essential tools for any Scientist or Engineer (and students too). And don't get me started on the lack of VBA support.
And why is Word such a RAM hog? Even running under Rosetta Word v.X uses only about 80 MB of real RAM when displaying a 200+ page report with embedded graphics. The same file under Word 2008 takes 200 MB!! And then it will jump to 700+ MB as soon as it starts to load some of the images in the file (JPEGs). Over 700 MB!!! Word v.X displays the images faster than Word 2008 and still only uses a fraction of the RAM (it may rise to 120 MB when scrolling through the images). I've tested this out on 2 Macs - a new MacBook Pro C2D 2.4 GHz (4 GB RAM) and a Mac Mini C2D 1.8GHz (2 GB RAM).
Same story on both machines. I'm very disappointed in my purchase.
I was very excited at the prospect of abandoning Word v.X and Excel 2004, but it looks as though I'll be using them for much, much longer. Feeling a little let down here. Office 208 does not have all the functions of Office 2004 (and vice-versa). Users need to very carefully compare features before deciding whether to upgrade. I would strongly advise scientific and professional users who have an older version to leave it installed, at least until they have proved that the new version has all the functions they need. Cheers On 16/01/08 2:09 PM, in article [email protected], 'Axon' wrote: Hi AdamI too was shocked to find this add-in missing. As a Scientist, I rely on this quite a bit for quick and dirty analyses.
Dec 06, 2016 Hi, There is no such add-in for the Mac. The Analysis Toolpak wasn't even available on Mac prior to the 2016 version. Today I am going to quick show you – with images – How to Add the Data Analysis ToolPak in Excel on Mac 2018. If you are just getting started in the data industry I would highly recommend checking out our full series on Data Analytics.
And did you happen to notice that the error bar functionality for charts has changed? In Excel 2004 I could specify a custom standard error term (located in the cell of my choice), but this feature is now gone from Excel 2008. What's going on?? Excel 2004 has this. Excel 2007 for Windows has this. Is Microsoft trying to water down Excel to appeal only to average consumers?
The analysis tool pack and the ability to specify custom error bars are essential tools for any Scientist or Engineer (and students too). And don't get me started on the lack of VBA support. And why is Word such a RAM hog? Even running under Rosetta Word v.X uses only about 80 MB of real RAM when displaying a 200+ page report with embedded graphics.
The same file under Word 2008 takes 200 MB!! And then it will jump to 700+ MB as soon as it starts to load some of the images in the file (JPEGs). Over 700 MB!!! Word v.X displays the images faster than Word 2008 and still only uses a fraction of the RAM (it may rise to 120 MB when scrolling through the images).
I've tested this out on 2 Macs - a new MacBook Pro C2D 2.4 GHz (4 GB RAM) and a Mac Mini C2D 1.8GHz (2 GB RAM). Same story on both machines. I'm very disappointed in my purchase. I was very excited at the prospect of abandoning Word v.X and Excel 2004, but it looks as though I'll be using them for much, much longer.
Feeling a little let down here. Don't wait for your answer, click here: 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 Nhulunbuy, Northern Territory, Australia +61 4 1209 1410, mailto:[email protected]. Office 208 does not have all the functions of Office 2004 (and vice-versa). The Analysis Toolpack is not supported in Office 2008.
Users need to very carefully compare features before deciding whether to upgrade. I would strongly advise scientific and professional users who have an older version to leave it installed, at least until they have proved that the new version has all the functions they need. Cheers On 16/01/08 1:18 PM, in article [email protected], '[email protected]' wrote: I just bought Office 2008, and have been eagerly awaiting the new version of Office for months. As soon as I installed Office, I went to Excel and tried to use the Add-Ins tool to install the Data Analysis Toolpak (found in Office 2003 and Office 2007), but no Add-Ins are available. I really need the Data Analysis Toolpak for school and work.
Where can I find it? - Don't wait for your answer, click here: 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 Nhulunbuy, Northern Territory, Australia +61 4 1209 1410, mailto:[email protected].
Hi Diane, No. I don't have Entourage open at all.
I used it for about 10 min and decided it wasn't for me. Apple Mail and iCal in Leopard just suit my needs better. Thanks for the suggestion, but this seems like something inherent with the new version of Word (likely all the new bells and whistles).
All of the new and fancy GUI-goodness has to come at a price. Hi John, I think we were all led to believe that Excel 2008 was similar in functionality to Excel 2004. All the reviews I read prior to purchase made no mention of an additional drop in essential feature support (other than VBA). It was touted has having a revamped graphics engine, but was also rated as being basically the same as Excel 2004. And Microsoft really wasn't advertising the removal of additional features on their web site.
I truly hope that error bar functionality and add-ins will be reinstated through a subsequent software update because, as it stands now, Excel 2008 is not very useful to me (and perhaps, any other Scientist). Thanks for your comments! This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.B1544663 Content-type: text/plain; charset='ISO-8859-1' Content-transfer-encoding: 8bit On 1/16/08 12:33 PM, in article [email protected], ' wrote: Nowhere in any literature that I read was there any mention of Excel 2008 not supporting the Data Analysis Toolpak Add-In.
This really stinks. Excel is not very useful for statistical work if you don't have these tools. I can't understand why these wouldn't be included. This is quite frustrating. I've already installed Office 2008 and really like it, but this is a big problem for me.
Is there any way to get in touch with someone at Microsoft to find out if there is a solution to this? You can get register your thoughts with Microsoft by using the send feedback command in the Help menu. There is no solution to this other than time. All of us are waiting for Microsofts statement. The basic problem is that since there is no VBA, the analysis Tool pack (which is largely VBA) cant run. Bob Greenblatt MVP, Macintosh bobgreenblattATmsnDOTcom -B1544663 Content-type: text/html; charset='ISO-8859-1' Content-transfer-encoding: quoted-printable Re: Data Analysis Toolpak Add-In for Excel On 1= /16/08 12:33 PM, in article [email protected], ' = wrote: = Nowhere in any literature that I read was there= any mention of Excel 2008 not supporting the Data Analysis Toolpak Add-In. = This really stinks.
Excel is not very useful for statistical wor= k if you don't have these tools. I can't understand why these wouldn't= be included.
This is quite frustrating. I've already installed Office 2008 and really like it, but this is a big pr= oblem for me. Is there any way to get in touch with someone at Microso= ft to find out if there is a solution to this? You can get register your thoughts with Micros= oft by using the send feedback command in the Help menu.
There is no solutio= n to this other than time. All of us are waiting for Microsoft’s state= ment.
The basic problem is that since there is no VBA, the analysis Tool pac= k (which is largely VBA) can’t run. = - Bob Greenblatt MVP, Macintosh bobgreenblattATmsnDOTcom -B1544663. In article, [email protected] wrote: I just bought Office 2008, and have been eagerly awaiting the new version of Office for months. As soon as I installed Office, I went to Excel and tried to use the Add-Ins tool to install the Data Analysis Toolpak (found in Office 2003 and Office 2007), but no Add-Ins are available. I really need the Data Analysis Toolpak for school and work. Where can I find it?
![]() ![]()
Functions that used to be in the Analysis Toolpak Add-in (e.g., WEEKDAY, RANDBETWEEN, etc.) have been incorporated in XL. Wizards such as the Histogram wizard will not run in XL08 since VBA has been removed. No question - that sucks. However, the output of all the wizards can be obtained using built-in XL functions and commands (in some cases the quality of the output will be better - the ATP's Random Number Generator was pathetic). In article, wrote: Nowhere in any literature that I read was there any mention of Excel 2008 not supporting the Data Analysis Toolpak Add-In. Since the ATP Add-in uses VBA, it was a logical result, though admittedly, one had to have some understanding of the tool in order to know that.
This really stinks. Yes, it does. Excel is not very useful for statistical work if you don't have these tools.???? The ATP functions have been incorporated into XL, and the ATP VBA wizards don't provide any actual capability not provided by built-in functions. Yes, it's more work to do it using functions, but it's perfectly possible.
Note that in some cases, the ATP results were relatively poor - the Random Number Generator in particular was wholly inadequate by modern standards. I can't understand why these wouldn't be included. This is quite frustrating. I've already installed Office 2008 and really like it, but this is a big problem for me.
Is there any way to get in touch with someone at Microsoft to find out if there is a solution to this? If you post back here with your specific problem, you may be able to get a built-in function solution. Hi Axon: On 16/01/08 10:42 PM, in article [email protected], 'Axon' wrote: Hi JohnI think we were all led to believe that Excel 2008 was similar in functionality to Excel 2004. All the reviews I read prior to purchase made no mention of an additional drop in essential feature support (other than VBA). It was touted has having a revamped graphics engine, but was also rated as being basically the same as Excel 2004.
And Microsoft really wasn't advertising the removal of additional features on their web site. In Microsoft's defence, they did not 'remove' any features from the Universal Binary version of Microsoft Office for the Mac. They conducted a mad scramble to 'add' as many features from Office 2004 and Office 2007 as they could, given the time, people, and money available to them, from the time that Apple announced that they were going to Intel. What you see is all that they had the time/people/money to do. The point I am trying to make is that they didn't take any out, they simply couldn't add as many as they would have liked to. I truly hope that error bar functionality and add-ins will be reinstated through a subsequent software update because, as it stands now, Excel 2008 is not very useful to me (and perhaps, any other Scientist). I think that's most unlikely.
Sorry, but standard industry practice in the software industry is 'NEVER add functionality in updates, it pisses off our customer system administrators!' I do expect that the next version of Mac Office will arrive rather sooner than might be expected. But it would be very irresponsible of me to raise anyone's hopes that any of the missing functions will appear in an update.
I guess it's theoretically 'possible'. But if I were a betting man, I would not put the rent on it.:-) Cheers - Don't wait for your answer, click here: 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 Nhulunbuy, Northern Territory, Australia +61 4 1209 1410, mailto:[email protected]. In article, [email protected] wrote: Thanks for all the help, everyone. So, since I can't do any substantial data analysis in Excel 2008 as it currently exists, do y'all think that a third-party might come along with some sort of add-in, or is that even possible?
If not, can someone recommend some software that is good for the Mac for data analysis? I REALLY, REALLY hope Microsoft will come up with a solution for this. When can we expect to hear something from them? Adam What are you trying to do? The ATP did little or nothing that can't be done with built-in functions except create a wizard to make selecting ranges and criteria easier, and produce formatted output. Yes it's a PITA, but it's certainly possible to do substantial data analysis in XL08. For examples of how to do many of the ATP analyses using the ATP, see And it's certainly possible that one could write an applescript or Real Basic application to replace the ATP wizards.
Don't know what the demand will be. In article, [email protected] (Axel Hammerschmidt) wrote: Just out of curiosity, what functionality is provided in the ATP that can't be reproduced with built-in functions?
None, given enough time. But then why bother with Excel?
If it's not providing what you need, then.don't. bother, naturally. There are tons of statistical packages out there. However, this thread started out with the assertion that XL was useless for statistics without the ATP. I've never found that to be the case.
In fact, I've found nearly the opposite - most of my clients that really know statistics would never use the ATP. I also know a ton of scientists (primarily biologists and biological science students) who use the ATP t-tests, 99% of the time inappropriately. It seems the ease of using the ATP overrides their understanding (or lack of understanding) of the underlying population requirements. Does anyone have a document tracker using Excel; our office uses Access but I don't like it. I have a set of data list in the horizontal manner.
Is there a macro that can send this data vertically instead of manually doing it? Thanks in advance. Aloysicus One way. Assume source data is in Sheet1, A1:E1 In Sheet2 Put in A1: =OFFSET(Sheet1!$A$1,COLUMNS($A$1:A1)-1,ROWS($A$1:A1)-1) Copy A1 down by as many rows as there are columns in Sheet1, i.e. Down to A5 A1:A5 will return whats in A1:E1 in Sheet1 - Rgds Max xl 97 - GMT+8, 1 22' N 103 45' E xdemechanik yahoocom - 'Aloysicus' wrote in message ne.
When files are already open by another user, we have found that only users with Administrator permissions on their computers are able to open files read-only. If the user only has basic user permissions they receive a message stating the file could not be found. This was not a problem with Office 2000 (which we recently upgraded from). Thanks, Chris. I am using MSExcel2000. I want the user to enter the password everytime they open the excel sheet. I tried to go the option Tools-Option but there is no Security Tab.
What is the other way in Excel2000 to set the password for the file? Hi you have to go to the Tools menu within the Saveas dialog ('File - Saveas') 'Ash' wrote: I am using MSExcel2000.
I want the user to enter the password everytime they open the excel sheet. I tried to go the option Tools-Option but there is no Security Tab. What is the other way in Excel2000 to set the password for. I ‘m building a column graph using Excel 2007 and I’m having difficulty aligning a series of data with the proper dates. I have 2 series of data – Series 1: Includes a value for each quarter in 2009 (e.g., Mar-09, Jun-09, etc).
Series 2: Includes a value for each quarter in 2010 (e.g., Mar-10, Jun-10, etc). After creating each series, I select the appropriate dates (Series 1 – 2009 dates / Series 2 – 2010 dates). The first issue that I’m having is that when I select the second set of dates (for Series 2), it overrides the first – so the x-axis initially shows 2009 dates, but then. Am in the process of performing an Alternate server recovery of an Exchange 2003 Information Store. The reason being that on the current server all the email has dissappeared from the public folder mail folders.its a very strange situation indeed. Hoping that by restoring an earlier backup to a different machine we can see if the emails will return. If they do, is there a way I could export the contents of these folders back into the current info store?
I gather that Exmerge will only work on Mailboxes and not Public Folders. Many thanks in advance, Neil On Fri, 19 Aug 2005 08:58. We want to develop some GP 9.0 add-ons having new tables in database, new logic and functions. Also need these add-ons integrated with GP seamlessly. What's the easiest way to do so?
Using VB Editor and Modifier, or VB and VB.net, or Dexterity? Are there any documents or demos for a newbie GP developer? I totally lost in the SDK document. A Chinese GP newbie comes. Pardon me if I asked a stupid question. Once the.Net extensions are released, they will be probably the best if you have an investment in the.Net platform and Visual Studio 2005. Today, you can use Dexterity to c.
I work for a powder coating company and want to make a program that will store all of the data on each part. I want to be able to go to the computer type in a part number and retrieve all of the data for that part. It has to be read onlyso that it can only be edited by a supervisor. I was told i could use excel for this and an 'at' function was mentioned. Thank you If the info fits in 256 columns, you can put the part number in column A and the info in B:IV.
Then apply data filter autofilter and use that to just show the parts you want. If the data is more than 256 columns, you co. When I try to name a file all I get saved is the first letter of the title I have entered. What is set wrong? Doesn't sound right. Show us the code that you use.
HTH Bob Phillips 'TonyB' wrote in message news:[email protected]. When I try to name a file all I get saved is the first letter of the title I have entered. What is set wrong? Check to see if Excel is running in Windows 95 compatibility mode. There was a post that said: When I disabled compatibility mode.
I am a frustrated Excel newbie. I grit my teeth every time I have to use Excel. But I need to create a small database of records and chart it's monthly progression, and I think Excel is probably the best program for the job.
Only, I don't know who to do this. Please bear with me as I really need help with this. Say that I have a short list of vendors in different cities. For each vendor I have a total # of items in their inventory and another # of the # of items sold from the inventory, and a percentage of that.
So I have the vendors listed in Column A. # of items in inventory. What is the difference between these? I have run the vb macro code on to check if i have any external data sources or data ranges but there are none. The reason i need to know is becuase i'm working with office sharepoint server 2007 and i cannot access a file thru the web access web part because it says: 'The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services: External data ranges (also called query tables)' anyone? I want to add a space (or any character(s)) after each text value in all the cells in a row or in a column For example, cell A2 contains 'ABC', cell B2 contains 'DEF', and so on. I want to make all the cells in row 2 to have a space so cell A2 contains 'ABC ', cell B2 contains 'DEF '.
Try going to an empty part of the sheet (say row a4) & type =a2&' ' or 'any character' then copy that across the row for your range. After calc you can copy the range & paste special (values) back into range a2.X2 &am. Error message: File cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.
The file was not saved as read-only and the file is on a diskette. Sounds like a bad disk. Copy the disk to the hard drive somewhere an try to open there.
kkkni - kkknie's Profile: View this thread: Vic Cop. Hi everyone I have another little problem.
I have got a list of 20 items on sheet1, Cells A1 - A20 (numbered 1 - 20) and Cells B1 - B20 are items relating to that number, ie, number 1 = Concrete, number 2 = walls, and so on. Now on sheet 2 I have a table, again cell range A1:B20. I would like to know a formula so that when I enter a number in to column A, the corresponding item to that number appears in column B. Ie, if I enter number 8 in Cell A1 on sheet 2, then I would like Floor to appear in Cell B1. Does this make sense?
- Thanks in advance for your help Lee Hi Lee Data range i. Has anyone used DMF 3.0 to migrate data into CRM using its wizards or stored proceedures? What happened and how did you do it? Andy It's a bit unwieldy, but if you follow the documentation closely and do thorough tests it is a helpful tool. You should be prepared to do some extensive data cleansing and search the newsgroups when you hit a roadblock. Matt Wittemann, CRM MVP 'Andy' wrote: Has anyone used DMF 3.0 to migrate data into CRM using its wizards or stored proceedures?
What happened and how did you do it?. How do I check a certain row to find out the last column in the row that has data? Dim myRow as long dim LastCol as long myrow = 1243 with worksheets('SomeSheetnamehere') lastcol =.cells(myrow.columns.count).end(xltoleft).column end with msgbox LastCol This will break if you've used the last column in that row - or if you haven't used any cells in that row. Is that a problem? Bishop wrote: How do I check a certain row to find out the last column in the row that has data? - Dave Peterson This gives a interger.
In column K, I have different information. Each cell either says 'Returned' or 'Disposed.' In K35, I would like to have a total of all the cells in the column which show 'Returned' and in K36, I would like to have a total of all the cells in the column whith show 'Disposed' Thanks Please don't multipost.
In article, 'That's Confidential' wrote: In column K, I have different information. Each cell either says 'Returned' or 'Disposed. I have the following data F1 F2 D1 D2 F01 1 10 1 F02 2 20 3 F01 2 30 6 F01 5 40 4 F02 6 40 5 F1 to be presented in rows F2 to be presented in columns D1.
D2 to be presented as data Is that possible without defining an extra column in my source data? Regards, Louis Louise - Yes, it's a calculated pivottable field.
Once you have the pivottable established except for the data values, select Options tab, Formulas drop down arrow, calculated field. 'loconel' wrote: I have the following data F1 F2 D1 D2 F01 1 10 1 F02 2 20 3 F01 2 30 6. I have a byte array in memory for a file and also its filename (actually a mail attachment).
Now I want to 'open' this file. In case of a '.doc' file I have to find the association (winword), run that program and give it a path to my memory or something like that. I think the simplest way to achieve this is to save the data into a temp file (GetTempPath + actual file name, overwriting any previous one), and then running RunCmd somehow and Windows knows what to do. I know how to write the file, but a RunCmd command doesn't exist or I haven't found some. Hi, is it only possible to add a combo box to a user form?
If i create a generic function i'd like to be accessible to me anytime (like th sum function int he toolbar but different) what would be the best wa fo doing it (ie. A button i click but a button that's always visible). A simple button can be made into a user created toolbar, but if thi function of mine has certain options and I'd like to show those option in a combo box (Well only one option:) and have a command butto beside that. (I guess that would be a combo box with a list and command button) can I put these two.
I have a master file and 4 workbooks where individuals enter info daily. I need to update the master file workbook at the end of the day with the info from the 4 individual notebooks. How would I merge this data?
I tried the 'shared workbooks' process but it wouldn't let me do it. Since your question is very 'general', here's a 'general' suggestion: Explore the use of links. Have all WBs open. Right click in a pertinent data cell of one of the 4 WBs, and choose 'Copy'.
Navigate to the appropriate cell in the 'Master&quo. Hi, I need to create a chart that is based on changing values. The Values are all stored vertically in a Worksheet called Percentage.
The chart sheet contains a selection box where the user can select a specific search and a date and the selected conditions should be searched for and the chart should display results. Basically, when the user selects X in the first list box and Y in the second one, the code should search the Percentage worksheet for all instances of value=x and y and output. Column Row Feature1 Feature2 Feature3 2000 0.5 8.3 10 2000. There is no problem in opening a Excel97 file into Excel 2003. The problem occurs when trying to perform 'Save As' after that.
The error message is 'Excel cannot complete this task with available resources. Choose less data or close other applications.' The file is only about 2.5MB and there is no other applications running in the background except the normal firewall and antivirus programs.
The interesting thing about this problem is that, it occurs on one PC and not on another? Both PC got 512MB DDR Ram and plenty of space in hard drives.
The total paging s. Does anyone know of a.project management template. for Excel. I don' have Microsoft Project on my computer, nor do I have the time to lear it.
I use Excel thoroughly so that is my preference. Thank you - Message posted from Try Tushar Mehta's Gantt chart: Hope this helps! Anne Troy (better known as Dreamboat) Author: Dreamboat on Word Email: Dreamboat.at.Piersontech.com Web: www.TheOfficeExp. Hi, I am trying to create a pie chart from the below data just to show the percentages of what work orders are maj, med and min. How do I set this up!! Thanks in Advance!!!
How can i create a pie char By following the directions within the Chart Wizard. Regards, Tushar Mehta, MS MVP - Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article, [email protected] says. how can i create a pie chart.
Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |