Issue: User is able to open the (refer attached) excel sheets containing Pivot Tables having hidden rows, columns & worksheets. Below is the prompt it throws: This workbook contains content that is not supported by Excel 2008 for Mac. When you open file as Read-Only, it shows #VALUE! In the cell content. I have unhide all the hidden rows, columns & worksheets still issue persists. The same works fine on Excel 2007 on windows platform.
Has anybody faced similar issue or having any known KB article, which confirms that there are compatibility issues with Windows and Mac versions of MS Office.
Excel 2016 vba and macros includes content update program mrexcel Thu, 06 Dec 2018 00:24:00 GMT excel 2016 vba and macros pdf - SAVE TIME. Supported or updated by Microsoft, the VBA programming language was. VBA Workbook - Excel Macro Mastery - To send emails from Microsoft Excel only requires a few simple scripts.
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, I received a message when reading a workbook created on Excel 2007: This workbook contains content that is not supported by Excel 2008 for Mac. more than two data filter criteria - more than two sorting criteria - unsupported PivoTable report styles The worse thing is I can open as read-only workbook and If I change something and save my work, the unsupported content will not be saved! Someone knows how to handle this issue? Microsoft will fix it in Office 2011?
Thanks for any help Wagner. Sorry, Wagner; Nobody here has any more idea than you do of what will arrive in Mac Office 2011. Or at least if they do they are under strict NDA to not divulge or discuss any information not officially released by Microsoft. It is generally expected that feature parity will be greatly improved, but in what ways or to what extent not only isn't known, but is subject to change before the product is actually released. There's no question that the Office 2007/2010 apps include numerous features not supported in Office 2008, but I'm afraid there is no way to 'handle' that other than to accept the reality of it & work accordingly.
Any files destined for a platform/version other than that in which they are created need to be designed with those differences in mind. Regards :) Bob Jones MVP Office:Mac On 5/11/10 4:51 PM, in article [email protected], '[email protected]' wrote: Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel HiI received a message when reading a workbook created on Excel 2007: This workbook contains content that is not supported by Excel 2008 for Mac. - more than two data filter criteria - more than two sorting criteria - unsupported PivoTable report styles The worse thing is I can open as read-only workbook and If I change something and save my work, the unsupported content will not be saved! Someone knows how to handle this issue?
Microsoft will fix it in Office 2011? Thanks for any help Wagner. On 5/11/10 4:51 PM, [email protected] wrote: Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel HiI received a message when reading a workbook created on Excel 2007: This workbook contains content that is not supported by Excel 2008 for Mac. - more than two data filter criteria - more than two sorting criteria - unsupported PivoTable report styles The worse thing is I can open as read-only workbook and If I change something and save my work, the unsupported content will not be saved! Someone knows how to handle this issue? Microsoft will fix it in Office 2011?
Thanks for any help Wagner I am not sure what your question is. The Mac functionality is different from the windows functionality is several areas. When you open a Windows file on the mac containing stuff the Mac does not understand you get that message. Since the Mac does not 'understand' it, it can not save the changes. To find out if it will be different in Office 2011, keep watching Mactopia for feature announcements.
Bobgreenblattatmsndotcom. I doubt that you'll ever see the gap 'eliminated' - at least not until the Mac market closely rivals the Windows market. There are too many differences in the respective Mac/PC operating environments.
Not to mention that the Windows market constitutes 80% my arbitrary number - it's probably higher of Microsoft's business. Consequently the Win Office group gets the lion's share of the development budget. MacBU is a self-supporting entity within the corporate structure, so they have neither the budget nor the manpower to 'reproduce' the same product.
It isn't just a matter of slapping a different label on boxes containing the identical software. Regards :) Bob Jones MVP Office:Mac On 5/13/10 6:31 AM, in article [email protected], '[email protected]' wrote: Thanks Bob, I work for a company (as a consultant) where everybody has Office 2007 but me. I hope Microsoft eliminates the gap between Mac and PC soon otherwise I will need to install Windows and Office 2007, which is not that I wanted. It should be The only difference in code should be the GUI for each Platform. Would save money in the long run if they did. If MS would get away from that stupid DOS mentality and go to UNIX which is a far better system Then all they would need to do is just change the GUI according to the Platform. Despite years and the Layers of windows deep down MS Operating system are still x86 based.
CyberTaz wrote: I doubt that you'll ever see the gap 'eliminated' - at least not until the Mac market closely rivals the Windows market. There are too many differences in the respective Mac/PC operating environments. Not to mention that the Windows market constitutes 80% my arbitrary number - it's probably higher of Microsoft's business. Consequently the Win Office group gets the lion's share of the development budget.
MacBU is a self-supporting entity within the corporate structure, so they have neither the budget nor the manpower to 'reproduce' the same product. It isn't just a matter of slapping a different label on boxes containing the identical software. Regards :) Bob Jones MVP Office:Mac On 5/13/10 6:31 AM, in article [email protected]'[email protected]' wrote: Thanks Bob, I work for a company (as a consultant) where everybody has Office 2007 but me. I hope Microsoft eliminates the gap between Mac and PC soon otherwise I will need to install Windows and Office 2007, which is not that I wanted. - Phillip M.
Jones, C.E.T. 'If it's Fixed, Don't Break it' mailto:[email protected]. Well, I think you will find the gap is a lot smaller in Office 2011 for Mac:-) On 13/05/10 8:31 PM, in article [email protected], '[email protected]' wrote: Thanks Bob, I work for a company (as a consultant) where everybody has Office 2007 but me. I hope Microsoft eliminates the gap between Mac and PC soon otherwise I will need to install Windows and Office 2007, which is not that I wanted. The email below is my business email - Please do not email me about forum matters unless I ask you to; or unless you intend to pay! John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer, McGhie Information Engineering Pty Ltd Sydney, Australia. Ph: +61 (0)4 1209 1410 mailto:[email protected].
Hi Phillip: Really it is time you took a look around you! It's fine to be a hopelessly one-eyed fanbois, but to do so, you need to be right up-to-date. Being ten years behind the times does nothing for one's street-cred:-) DOS will not run on current Microsoft Operating Systems. Yes, Unix is a far larger system than DOS. Unix is a development from DOS. And DEC VMS was a development from Unix. And Windows was a development from VMS.
Can you see where this is going? Quit throwing stones, you're living in a glass house:-) If the same code WERE to run on both platforms, the cost would be more than double.
Is that what you really want? In a GUI application, around 80 per cent of the 'work' is done by the operating system.
So unless you want to replicate the whole of Windows into Excel, I am afraid you are going to have to accept that there will be some differences. Repeating the same old disinformation time after time and hoping someone will believe it doesn't even work in Washington, these days! Cheers On 13/05/10 11:51 PM, in article [email protected], 'Phillip Jones, C.E.T.' Wrote: It should be The only difference in code should be the GUI for each Platform. Would save money in the long run if they did. If MS would get away from that stupid DOS mentality and go to UNIX which is a far better system Then all they would need to do is just change the GUI according to the Platform. Despite years and the Layers of windows deep down MS Operating system are still x86 based.
CyberTaz wrote: I doubt that you'll ever see the gap 'eliminated' - at least not until the Mac market closely rivals the Windows market. There are too many differences in the respective Mac/PC operating environments. Not to mention that the Windows market constitutes 80% my arbitrary number - it's probably higher of Microsoft's business.
Consequently the Win Office group gets the lion's share of the development budget. MacBU is a self-supporting entity within the corporate structure, so they have neither the budget nor the manpower to 'reproduce' the same product. It isn't just a matter of slapping a different label on boxes containing the identical software.
Regards :) Bob Jones MVP Office:Mac On 5/13/10 6:31 AM, in article [email protected]'[email protected]' wrote: Thanks Bob, I work for a company (as a consultant) where everybody has Office 2007 but me. I hope Microsoft eliminates the gap between Mac and PC soon otherwise I will need to install Windows and Office 2007, which is not that I wanted. - The email below is my business email - Please do not email me about forum matters unless I ask you to; or unless you intend to pay! John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer, McGhie Information Engineering Pty Ltd Sydney, Australia.
Ph: +61 (0)4 1209 1410 mailto:[email protected]. The charting function in my Office 2007 installation not working.
When I click the Chart button, it shown following message. Information - Some chart types cannot be combined with other chart types. Select a different chart type. OK - I have both Office 2003 and 2007 installed in my system. Is this a compatible issue?
I had try the chart function in Word, Excel and PowerPoint all not working. Thanks did you ever figure out the problem? I'm getting the same error in office 2007. How doe I insert the date on which the workbook was last saved into a worksheet?
- Bodene - Bodene's Profile: View this thread: This code should log the save date and time to cell A1 of the active sheet in the book. Range('A1').ActiveWorkbook.BuiltinDocumentProperties(12).Value How and where you use the code depends if you need the refreshing of the data to be automatic. Join our webinar on Excel Pivot Tables to gain full knowledge on Pivot Tables. This webinar will be conducted on three parts and each part will be conducted one day.
You can take part for any one part of this webinar or can attend for all the ones. Our well-versed presenter who has a background in financial reporting, budgeting and forecasting, and database designing will provide you this webinar.
By attending this 3 parts of webinar you will get =E2=80=9C4.5 Computer Science=E2=80=9D CPE Credits. Webinar Title: Excel Pivot Tables (Part 1, 2, 3) Webinar Start Date: December 13th 2011 Regis.
Dear Experts: With some cells in a colum selected (say 10 selected cells in a column: contiguous range) I would like a macro to copy the contents of these cells and paste the contents of each cell in separate text fields. Is this feasible? Help is much appreciated.
Thank you very much in advance. Regards, Andreas More info and before/after examples - Don Guillett Microsoft MVP Excel SalesAid Software [email protected] 'andreashermle' wrote in message news:21aa7180-a39e-405a-a3fd-ec98d8e6f7db@j19g2000yqk.googlegroups.com. Does anyone know how to scale the chart area in excel?? Here is a synopsis of my problem.
I created a chart and pasted it into word. I changed the page setup in word to landscape and made the chart as big as possible to fit on one page.
I understand if I mess with the size, I can make it scale corectly. It appears that the scale is like 2 in the x direction and 1 in the y.
I would like to know if there is a way to define the x and y scale so that the grid lines are a 1 to 1 scale. Any comments or suggestions would be appreciated. Jon Peltier has instructions for making gridlines squa.
This is a daft one, but I can't find a solution anywhere. Everytime I open a workbook it opens in the same window as the last one.
There was a time, in the dim and distant past when each time I opened a workbook, it opened in a new seperate window. Tiling windows annoys me, I want two copies of excel running independently.
I just can't figure it out. I know its obvious and stupid, but please help!
Cheers, Ben On Fri, 12 Sep 2003 03:52:58 -0700, 'Bungers' wrote: This is a daft one, but I can't find a solution anywhere. I want to open a linked Excel Sheet with the appropriate range. The excel filename / range I have is the following: C: Documents and Settings aparmar Desktop Book1.xslx!Sheet!R1C1:R5C2 I'm opening the following by stripping of the extra information: C: Documents and Settings aparmar Desktop Book1.xslx How do I select the Range in Excel using!Sheet!R1C1:R5C2? Thanks, Amrit Command lines to open workbooks do not include specific sheets and ranges. To open to a specific sheet and range selection you must use VBA Name the range then add this code to Thisworkbook module of Book1.
I'm not sure if this is an excel function or an access function. (I don't know Access - however I'm fairly well versed at Excel). My company has a separate Excel spreadsheet with data for each client.
We'd like to continually update the data in the client specific spreadsheet and have a separate worksheet that regularly pulls the data from all clients/all worksheets that we may then reference, sort etc. How would we go about establishing this? - Cathy Hi Cathy Maybe the Merge Add-in or code from my site will help you See the 'Copy/Paste/Merge example.
Where can find an API HOOK code(That is strong and stably support 98 & NT)?? Thanks First. Google for APISPY joe On Wed, 20 Oct 2004 11:00:08 +0800, 'me' wrote: where can find an API HOOK code(That is strong and stably support 98 & NT)?? Thanks First.
Newcomer MVP email: [email protected] Web: MVP Tips: I have 3 workbooks tied together with links. One is a source only, the other two push and pull data. One of the sources, Payroll Master, on opening updates all links fine to the source only workbook but not to the third workbook (which is in the parent directory). Every time I open it it prompts me to show it where the Payroll Entry is. Doesn't matter if I hit cancel and do Edit Links, I can change it there, but will still lose it upon closing (the link appears in the box and looks ok, just won't update.) Try going Edit-Links.
Break the link and re-establish it? I have an Excel table linked to Access. The text in Excel is forced to wrap (I've tried both Alt-Enter and using Char(10) in an expression - same result). Char(10) or Alt/enter code shows up as a little box in Excel with no forced wrap. Here's the text in Excel (shows up as text, not dates) '12/12/05 1/03/06 3/22/06' Here's what I get in Access 12/12/05(little box)1/03/06(little box)(little box)3/22/06.
Has anyone else noticed that the scroll bar (in Excel 2003) on the forms menu does not scale in size smoothly. It gets a severe case of the 'jagges' as you scale it up in size. It is also MS blue in color.
The spinner button on the same bar is still gray and black. Wonder if this was intentional or? Pieter Vandenberg You're right on both counts. The scroll bar is truly hideous when widened to a certain point.
It's interesting too that the list box has become blue while the drop down is still black. These differences are only apparent though when I have the 'Windows. I`m new to this group so greetings for everybody:). My questions (MS Excel 2007): There are 10 separate files, each containing a similar worksheet. There is an eleventh, cumulative file, containing a chart from these ten files. The number of files grows constantly.
I would like the charts in the cumulative file to change, based on the newly created files. How to do this in a possibly automatic manner?
For example: 5 persons are evaluated each month with a 10-question test and get a grade (from 1 to 5)for each question. In the cumulative file there is a chart depicting the mea.
I have distribution list which contain 100 entries. Iam unable to send.
Can any one help me out. Regard vishal Contact your ISP to see what limits they put on Distribution Lists. Milly Staples MVP - Outlook Post all replies to the group to keep the discussion intact. After searching google.groups.com and finding no answer: abbagani vishal asked: I have distribution list which contain 100 entries.
Iam unable to send. Can any one help me out. regard vishal are you getting any errors? - Diane Poremsky MVP - Outlook Author, Teach Yourself. In a cell in workbook no.1 I have this eneterd No.8-CRP-B1, in a cell in workbook no.2 in A7 i want to link this cells so it read the same and will update when updated. So I opened bolth notebooks whe into workbook no.2 and cell A7 entered = and then highlighted the cel in workbook no.1 for some reason I get the response #value why is this when I do this with other cells I have no problem?
Thanks for the help - MIKE0 - MIKE0W's Profile: View this thr. In the report properties code window, does SSRS support C# or VB only? Hello, I want to copy and paste several cells, each containing formulas, from one workbook to another.
The formulas contain references to several different sheets and I want the paste to contain the formulas exactly as they are in the originating workbook. When I paste these cells into the destination workbook, however, the formulas have inserted in them links to the originating workbook file name. The only way I can see to solve this problem is to individually select each cell, copy its formula from the edit formula field and then paste it into the edit formula field in the dest. I am tired of resetting page attributes on similar worksheets within a workbook. Seems like one should be able to copy print settings (margins, footers, headings, font, etc. Etc.) from one worksheet to another with one click like the format brush.
What am i missing? Must I write a print macro to do this on each and every multiple set of worksheets?
Try selecting the multiple sheets first, then setting the attributes. Just remember to ungroup them before you make changes that.don't. apply to all. In article, David Greenberg wrote: Not cells,rows,columns,sheets, the entire document, delete the entire thing. You can do it with a macro using KILL - Don Guillett Microsoft MVP Excel SalesAid Soft.
I downloaded a template for Excel to my computer. When I use the template, the colors in other workbooks change. After I reboot, it all goes back to normal, until I open the template again. Can somebody help me with the below expression?
I am getting a syntax error. Much appreciated. Docmd.TransferSpreadsheet (acImport,acSpreadsheetTypeExcel9,'DrawingsCurrentRevImport','C: Documents and Settings swichman My Documents ABFJV SubmittalReports/ PMIVExport.xls',) Without even testing or looking up the function I notice a forward slash in your path?
'C: Documents and Settings swichman My Documents ABFJV SubmittalReports/PMIVExport.xls' Shouldn't it be 'C: Documents and Settings swichman My Documents ABFJV SubmittalReports PMIVExport. I have two users in my office that use 2007 - myself and my manager. This morning something strange happened to a spreadsheet he was working on. There was data in the first 200 lines of the spreadsheet. Somewhere around line 35 and up to line 60 the data - dissapeared. You couldn't see the text in the cells.
BUT if you clicked in the cells you could see the info in the formula bar. He clicked save, and then it showed all the information again. This has happend several times over several spreadsheets. Can anyone help explain this?? Hello, I am new to excel and i have three columns (A,B,C,ect) of info and about 5000 rows (1,2,3,ect). Not sure if those are the correct names. I am trying to figure out how i can get every number in the B column to be multiplied by 7.25.
All I have found on the net so far is how to multiply it by another cell, but thats not what I need. Can someone please help me or I am looking at alot of extra hours. Thanks in advance. Type 7.25 in an unused cell.
Highlight the cell, select Edit, Copy, the select all cells in column B you want multiplied, then select Edit, Paste Special, Multipl. How to delete the same columns across a workbook Hi, Hold down the CTRL key and click each sheet tab to group them. On the visible sheet delete the column abd it will be deleted on all grouped sheets. Click a sheet tab to un-group sheets. Mike On 5 Jan, 19:39, RPM wrote: how to delete the same columns across a workbook.