I've made edits to a worksheet but nothng substantial or of note. The only thing that might be suspect is that I edited some VBA language for a macro but that is all. When my colleague attempts to open the document it gives an error related to unreadable content which is removed. The parts removed were pivot tables. I've attached a Word Document that displays the error messages and code.
Any help would be greatly appreciated.
Thanks!
what version is your friend using?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have 2007. They have 2010. But they have been able to open workbooks that I have created in 2010. All of the files mentioned here were in .xlsm format, not xlsx. It might be something specific to the workbook that is incompatible to 2007...?
I mean I have 2010. They have 2007
Try saving it again, using a different name, and then see if they can open it?
If they still cant, maybe remove a sheet at a time, and see if they can open it (in other words, try to track down what is causing the problem - I doubt it will be a 2007/2010 compatability problem)
edit: if you have 2010, I suggest you update your profile
Thanks FDibbins.
When looking at the workbook, I noticed something in the pivot table, which seems to be the unreadable content for my colleagues, where the filter for one field is giving me a warning alerting me that not all values are showing. I have not encountered this kind of warning before and it only seems to be unique to this workbook. I have attached the warnings in a word document.
have you refreshed the PT? would it be possible to just re-create it and delete the current 1?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks