Hi,
I get the following error message when trying to save a template (kind of, anyway, my version is in Swedish):
'Excel cannot complete task with available resources. Choose a smaller amount af odata or close other applications' (OK button only)
This is followed by an immediate new msgbox:
'External link values can not be saved.' (OK only)
History repeats itself once (both msgboxs pops up again), and thereafter the file is saved - as i should.
There is no problem closing / opening up the file again afterwards, everything is fine.
I also have problems relinking (change source in edit links) a file - msgbox 'cell too long', and it tries again, msgbox the same, looped in eternity --> force close application . I use 'replace' (ctrl + H) instead, works like a clock.
The problems, both of them, probably has something to do with that I first had too long formulas / functions which were including external links. The pathway's to the cells were OK when the linked files were open, but once I closed them --> msgbox 'cell to long'.
Well, that has been fixed, and that issue is not a problem anymore, but the saving and relinking problem hangs on... have tried in both Excel professional 2003 and previous versions.
Any ideas? Thanks in advance
// Patrik
I get the following error message when trying to save a template (kind of, anyway, my version is in Swedish):
'Excel cannot complete task with available resources. Choose a smaller amount af odata or close other applications' (OK button only)
This is followed by an immediate new msgbox:
'External link values can not be saved.' (OK only)
History repeats itself once (both msgboxs pops up again), and thereafter the file is saved - as i should.
There is no problem closing / opening up the file again afterwards, everything is fine.
I also have problems relinking (change source in edit links) a file - msgbox 'cell too long', and it tries again, msgbox the same, looped in eternity --> force close application . I use 'replace' (ctrl + H) instead, works like a clock.
The problems, both of them, probably has something to do with that I first had too long formulas / functions which were including external links. The pathway's to the cells were OK when the linked files were open, but once I closed them --> msgbox 'cell to long'.
Well, that has been fixed, and that issue is not a problem anymore, but the saving and relinking problem hangs on... have tried in both Excel professional 2003 and previous versions.
Any ideas? Thanks in advance
// Patrik
