Hey amit, can you share the example sheet.
On Wed, Aug 17, 2011 at 11:00 AM, Amit Desai (MERU) <amit.de...@merucabs.com> wrote: > Thanks, but this did not worked..I have updated few data in sheet1, after > pressing cltr+shift+S, selected the entire range, than given the name of > sheets where we have Pivots. > > Best Regards, > Amit Desai > > Assistant Manager, Fleet MIS (Corporate) > Desk No.: 022 40520129 > Cell No.: 9867232534 > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of XLS S > Sent: Wednesday, August 17, 2011 1:56 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Update Data source range & converting "0" to > "-" > > please ignore previous attachment ...........just press cltr+shift+S then > select new range for pivot... then ok...........then enter sheet > name................ > > > > On Wed, Aug 17, 2011 at 1:50 AM, XLS S <xlst...@gmail.com> wrote: >> hey Amit, >> >> try this code..... >> >> Sub ChangePivotRange() >> On Error GoTo Err: >> Dim Pt As PivotTable >> Dim rng As Range >> Set rng = Application.InputBox("Please Select a range for Pivot >> Table!", "XLS S Power", Selection.Address, , , , , 8) wsa = >> InputBox("Please Enter Sheet Name", "XLS S Power") For Each Pt In >> Sheets(wsa).PivotTables Pt.PivotTableWizard SourceType:=xlDatabase, >> SourceData:=rng Next >> Err: >> End Sub >> >> >> >> On Tue, Aug 16, 2011 at 4:30 PM, Amit Desai (MERU) >> <amit.de...@merucabs.com> wrote: >>> Dear All, >>> >>> >>> >>> Still waiting a solution for below issue. >>> >>> >>> >>> I have created several pivot tables & want to update the data source >>> range for all the pivot tables all together. (We do have option as >>> refresh all for applying the preset pivot criteria in all pivots.) >>> >>> Best Regards, >>> >>> Amit Desai >>> >>> >>> >>> Assistant Manager, Fleet MIS (Corporate) >>> >>> Desk No.: 022 40520129 >>> >>> Cell No.: 9867232534 >>> >>> >>> >>> From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com] >>> Sent: Thursday, August 11, 2011 4:16 PM >>> >>> To: 'excel-macros@googlegroups.com' >>> Subject: RE: $$Excel-Macros$$ Update Data source range & converting >>> "0" to "-" >>> >>> >>> >>> Thanks this one helped me.. >>> >>> >>> >>> Can you please also reply on below request; >>> >>> >>> >>> I have created several pivot tables & want to update the data source >>> >>> range for all the pivot tables all together. (We do have option as >>> refresh all for applying the preset pivot criteria in all pivots.) >>> >>> >>> >>> Best Regards, >>> >>> Amit Desai >>> >>> >>> >>> Assistant Manager, Fleet MIS (Corporate) >>> >>> Desk No.: 022 40520129 >>> >>> Cell No.: 9867232534 >>> >>> >>> >>> From: excel-macros@googlegroups.com >>> [mailto:excel-macros@googlegroups.com] >>> On Behalf Of Rajan_Verma >>> Sent: Thursday, August 11, 2011 3:02 PM >>> >>> To: excel-macros@googlegroups.com >>> Subject: RE: $$Excel-Macros$$ Update Data source range & converting >>> "0" to "-" >>> >>> >>> >>> See if it helps, I use conditional Formatting >>> >>> >>> >>> From: excel-macros@googlegroups.com >>> [mailto:excel-macros@googlegroups.com] >>> On Behalf Of mrinal saha >>> Sent: Thursday, August 11, 2011 11:46 AM >>> To: excel-macros@googlegroups.com >>> Subject: Re: $$Excel-Macros$$ Update Data source range & converting >>> "0" to "-" >>> >>> >>> >>> See the attached file, does it make sense.. >>> >>> >>> >>> regards, >>> >>> Mrinal Saha >>> >>> On Thu, Aug 11, 2011 at 10:37 AM, Amit Desai (MERU) >>> <amit.de...@merucabs.com> wrote: >>> >>> Dear All, >>> >>> Please help me on the following; >>> >>> 1) I have created several pivot tables & want to update the data >>> source range for all the pivot tables all together. (We do have >>> option as refresh all for applying the preset pivot criteria in all >>> pivots.) >>> 2) I have few work sheets where in I get the data through formula. >>> There may be many cells where I might get data as "0"(zero). I want >>> to make all the "0" as "-". But the total of these "-" I want as "0". >>> >>> Best Regards, >>> Amit Desai >>> >>> >>> Disclaimer: This message and its attachments contain confidential >>> information and may also contain legally privileged information. This >>> message is intended solely for the named addressee. If you are not >>> the addressee indicated in this message (or authorized to receive for >>> addressee), you may not copy or deliver any part of this message or >>> its attachments to anyone or use any part of this message or its > attachments. >>> Rather, you should permanently delete this message and its >>> attachments (and all copies) from your system and kindly notify the > sender by reply e-mail. >>> Any content of this message and its attachments that does not relate >>> to the official business of Meru Cab Company Pvt. Ltd. must be taken >>> not to have been sent or endorsed by any of them. Email >>> communications are not private and no warranty is made that e-mail >>> communications are timely, secure or free from computer virus or other > defect. >>> >>> -- >>> --------------------------------------------------------------------- >>> ------------- Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips >>> and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >>> >>> >>> -- >>> --------------------------------------------------------------------- >>> ------------- Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips >>> and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >>> -- >>> --------------------------------------------------------------------- >>> ------------- Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips >>> and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >>> ________________________________ >>> Disclaimer: This message and its attachments contain confidential >>> information and may also contain legally privileged information. This >>> message is intended solely for the named addressee. If you are not >>> the addressee indicated in this message (or authorized to receive for >>> addressee), you may not copy or deliver any part of this message or >>> its attachments to anyone or use any part of this message or its > attachments. >>> Rather, you should permanently delete this message and its >>> attachments (and all copies) from your system and kindly notify the > sender by reply e-mail. >>> Any content of this message and its attachments that does not relate >>> to the official business of Meru Cab Company Pvt. Ltd. must be taken >>> not to have been sent or endorsed by any of them. Email >>> communications are not private and no warranty is made that e-mail >>> communications are timely, secure or free from computer virus or other > defect. >>> >>> -- >>> --------------------------------------------------------------------- >>> ------------- Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips >>> and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> ......................... >> > > > > -- > ......................... > > -- > ---------------------------------------------------------------------------- > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and > Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > Disclaimer: This message and its attachments contain confidential information > and may also contain legally privileged information. This message is intended > solely for the named addressee. If you are not the addressee indicated in > this message (or authorized to receive for addressee), you may not copy or > deliver any part of this message or its attachments to anyone or use any part > of this message or its attachments. Rather, you should permanently delete > this message and its attachments (and all copies) from your system and kindly > notify the sender by reply e-mail. Any content of this message and its > attachments that does not relate to the official business of Meru Cab Company > Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. > Email communications are not private and no warranty is made that e-mail > communications are timely, secure or free from computer virus or other defect. > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ......................... -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
