Re: $$Excel-Macros$$ accessing server data

2010-02-23 Thread Dilip Pandey
Hi Madaiah, I believe they will get the #REF! Error as they do not have the access rights to server. My suggestion would be that after accessing the data using fomulas, you need to paste them as values before sending them to the end users. Alternatively, you can break links as well. -- Thanks &

Re: $$Excel-Macros$$ accessing server data

2010-02-23 Thread Putta Madaiah
Hi Dileep, Thanks for the reply.. How I can break those links by retaining the values..? Regrds- Madaiah On Tue, Feb 23, 2010 at 7:55 PM, Dilip Pandey wrote: > Hi Madaiah, > > I believe they will get the #REF! Error as they do not have the access > rights to server. My suggestion would be tha

Re: $$Excel-Macros$$ accessing server data

2010-02-23 Thread Dilip Pandey
Hi Madaiah, Go to Edit->Links->Break Links. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Tue, Feb 23, 2010 at 8:01 PM, Putta Madaiah wrote: > Hi Dileep, > > Thanks for the reply.. > >

$$Excel-Macros$$ accessing server data

2010-02-08 Thread Putta Madaiah
Hi, To update one of the main Excel file I am accessing some data from the source excel files available in the server. Now I want to send the main excel file to few people who do not have access to this server. will they able to see the data or they get an error similarly like "#REF". Please advi