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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
