pluginguin
New Member
- Joined
- Aug 10, 2016
- Messages
- 21
- Office Version
- 2019
- Platform
- Windows
I have a file in which I have been working for over 2 years. Since a week or two the file suddenly freezes when adding records to the first sheet. After some time (on average between 5 and 10 minutes) it suddenly unfreezes again and my last entry was saved correctly.
I can not find a cause.... maybe someone can shead a light on it?
The file contains 10 sheets.
Fase-1 artikelbestand:
On this sheet a user enters new data in columns A-M, the subsequent columns are then populated by formulas.
This sheet has remained pretty much unchanged for a long time so I doubt the issue is here.
However, the freeze occurs whenever a user enters new data in column A.
Magento invoerblad:
This sheet uses formula's to combine data from several sheets: Fase-1 artikelbestand, Meta Titels, Descriptions Serie tekst, Marketingtekst and Productcategoriën.
There have been recent changes to the formulas on this sheet. Mainly in the rows with long descriptions and Meta Descriptions
Beschrijvingen_precalculaties:
This sheet only uses formula's to transpose data from Magento invoerblad:
Import_Beschrijvingen:
This sheet is fairly new. I have designed it and it's "helpers", the sheets: Beschrijvingen_precalculaties and Referenties, to create a Magento 2 Import file for descriptions and meta's.
The formula's here use data from the sheets, Beschrijvingen_precalculaties and Referenties.
So, if you've understood my story so far you will see that there is sort of a train. A user enters data in Fase-1 artikelbestand. That data is processed by formula's on Magento invoerblad: and that data is then processed by formula's on Import_Beschrijvingen:. Somewhere in the train is something that causes the spreadsheet to freeze up, when a user enters new data.
Can anyone tell me where the train malfunctions?
The file in question can be downloaded from the following location:
I can not find a cause.... maybe someone can shead a light on it?
The file contains 10 sheets.
- Fase-1 artikelbestand
- Magento invoerblad
- Import_Beschrijvingen
- Meta Titels
- Descriptions Serie tekst
- Marketingtekst
- Productcategoriën
- Beschrijvingen_precalculaties
- Referenties
- Kolomnummers
Fase-1 artikelbestand:
On this sheet a user enters new data in columns A-M, the subsequent columns are then populated by formulas.
This sheet has remained pretty much unchanged for a long time so I doubt the issue is here.
However, the freeze occurs whenever a user enters new data in column A.
Magento invoerblad:
This sheet uses formula's to combine data from several sheets: Fase-1 artikelbestand, Meta Titels, Descriptions Serie tekst, Marketingtekst and Productcategoriën.
There have been recent changes to the formulas on this sheet. Mainly in the rows with long descriptions and Meta Descriptions
Beschrijvingen_precalculaties:
This sheet only uses formula's to transpose data from Magento invoerblad:
Import_Beschrijvingen:
This sheet is fairly new. I have designed it and it's "helpers", the sheets: Beschrijvingen_precalculaties and Referenties, to create a Magento 2 Import file for descriptions and meta's.
The formula's here use data from the sheets, Beschrijvingen_precalculaties and Referenties.
So, if you've understood my story so far you will see that there is sort of a train. A user enters data in Fase-1 artikelbestand. That data is processed by formula's on Magento invoerblad: and that data is then processed by formula's on Import_Beschrijvingen:. Somewhere in the train is something that causes the spreadsheet to freeze up, when a user enters new data.
Can anyone tell me where the train malfunctions?
The file in question can be downloaded from the following location:
Fase1-nieuwe-artikelen-demo.xlsm
1drv.ms