we need to open linked file in some cases like if we used sumif ,Countif.. Rajan.
On 12/5/11, Veer <virbhardwaj...@gmail.com> wrote: > Dear B Sharma, > > if you dont want to open both files, u can merge all the worksheets of > both workbooks in one workbook. > > or u can attach your files as example to make practical solution. > > THanks > > Veer > > > On Dec 4, 4:14 am, B Sharma <sharma....@gmail.com> wrote: >> Dear friends >> thanks for replyinng >> >> But I havrent got my solution >> >> On Dec 3, 11:19 pm, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote: >> >> >> >> > Dear B. Sharma, >> >> > Read this article or use VBA Macro mentioned >> > thereby:-http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html >> >> > Thanks & regards, >> > Noorain Ansari >> > >> > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >> >> > On Sat, Dec 3, 2011 at 10:31 AM, B Sharma <sharma....@gmail.com> wrote: >> > > Dear Excel Experts... >> >> > > I have created two separate work book. >> > > 1st one is the database and 2nd one is the report / summary file >> >> > > now my query is that while checking the reports I dont want to open >> > > the database file ,, currently I have to open both file for working. >> >> > > Is there any easy way. >> >> > > 2ndly please give some tips so that I can minimize the size of the >> > > workbook. >> >> > > -- >> > > FORUM RULES (934+ members already BANNED for violation) >> >> > > 1) Use concise, accurate thread titles. Poor thread titles, like >> > > Please >> > > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> > > Advice >> > > will not get quick attention or may not be answered. >> >> > > 2) Don't post a question in the thread of another member. >> >> > > 3) Don't post questions regarding breaking or bypassing any security >> > > measure. >> >> > > 4) Acknowledge the responses you receive, good or bad. >> >> > > 5) Cross-promotion of, or links to, forums competitive to this forum >> > > in >> > > signatures are prohibited. >> >> > > NOTE : Don't ever post personal or confidential data in a workbook. >> > > Forum >> > > owners and members are not responsible for any loss. >> >> > > --------------------------------------------------------------------------- >> > > --------------------------- >> > > To post to this group, send email to excel-macros@googlegroups.com >> >> > --- Hide quoted text - >> >> - Show quoted text - > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
