LinkBack URL
About LinkBacks
arnab0711 
Hi,
When I try to copy cells from details sheet to dummy sheet the cells are not getting copied,I have marked them in yellow.
Hi,
When I try to copy cells from details sheet to dummy sheet the cells are not getting copied,I have marked them in yellow.
hi arnab0711, what do u mean when u say copy? your details sheet is a pivot. a copy & paste should be non-formula. if u need to use a formula to refer to a pivot, u have to disable GETPIVOTDATA or type in the cell reference manually. u cannot refer directly to the pivot.
to disable GETPIVOTDATA, go to File -> Excel Options -> Customise -> Choose Commands From: PivotTable Tools | Options Tab ->
Choose "Generate GetPivotData" & Add to your toolbar. Now u can uncheck the box & can link formulas to the pivot
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Now how to do that in excel 2007
i am describing it as per Excel 2007. attaching a printscreen for u
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks