Hylton Conacher(ZR1HPC) wrote: > > Hi, > > I have an extensive spreadsheet which I use to monitor my ADSL usage on > a monthly basis. Asides from a tab for each month I also have a Master > tab and the tabs for the graphs I have drawn from the data. All the > monthly sheets have the same layout as the master tab so therefore > changing the master tab would allow me to have a single source to copy > from so that I could paste in all the months tabs to reflect the new > data set-up/formula. > > What I would like to be able to do is link all the monthly static tab > details to my master sheet i.e. column headings and formulae but this > does not seem possible, or rather is possible with Paste..Special..Link > but then the actual data values, all being zero in my Master tab are > carried forward to wherever I have pasted the link and the data in the > monthly tab is not used. > > To try and get around this error I copied parts of the Master tab and > pasted it onto the monthly tab. This also did not work as the cell > references in the formulae I had in the Master tab changed to different > values when I pasted them. > > If anybody wants the spreadsheet concerned or if I can upload it to a > central bugs repository, please let me know where or what your email > address is. > > Regards > Hylton > Using OpenSUSE 10.2 with KDE > >
I suggest that, instead of using the "master tab" as your template, you create a separate sheet as a template and copy that each time you need a new sheet. It could be hidden when not required. -- View this message in context: http://www.nabble.com/OO-Calc-2.04-Cell-linking-and-Copy-and-Paste-error-tf3432528.html#a9583049 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
