Ihave a pivot table that gets data from a server.In my pivot table some cells do not have values.After the macro has run then on my report template all values are pasted, and the cells that was empty is now filled with zero's.What can i do so that in the report it still shown a blank cell,not zero's.
Software/Hardware used: excel 2003
Ask a Question
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!