Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Manage Calc Cell Name: Global Or By Sheet

Recent Calc versions seem to allow cell names to be defined either to document scope or only a sheet. Prior versions only allowed one cell name per document. No repeats.

I have a large excel spreadsheet provided by a third party. They use cell names and I have a second spreadsheet that has DDE links pulling data from the third party spreadsheet. All DDE links in the 2nd one depend on the 1st file's names to be global, but recent versions of calc are now seeing these names as per sheet.

Is there a way to have calc assume all names are global? Thank you! Paul