I use DDE Commands a lot to bring totals from one calc file to another & maybe I should be doing some other method & if so, let me know what to use.
The problem is when I have to insert tows into the first calc sheet which pushes the total down a row thus my other calc sheet cannot update properly as the row identity is wrong. For example (I changed personal information here:
=DDE(“soffice”,"//Users/username/Documents/1Stuff/Sheets/25Dailyt.ods","‘Credit Cards’.D623")
Now that row can be down to D623 or even further so I have to go & manually edit all my links in the other sheet trying to pull this information.
If I go to Edit Links in the file pulling the totals, the links are set to update automatically which works until I insert rows throwing my row off. Is there a way to dynamically get this to change?
Again, if I need to use another method I certainly can do that but I need the information of what to do.