Excel 2010 Crash DBRW and DBSW at same time

[Thijs.Spruijt]

Dear All,

We have build an active form. On top of that I created a VB macro which in principle
-Copy the DBRW part
-Past below in the sheet (first free row) as Value.
-Create DBSW formula's so users can copy and past.

Now in some exectional cases Excel Crashes without any reason.

I put off automatical recalc and disabled the recalc before save.

So my question. If in the Active form I have on the same combination a DBRW function and somewhere else in the sheet a DBSW function, could that cause problems? Which takes priority.

Any sugestion will be helpfull.

Thijs Spruijt

[sander]

Dou you use rdp, or is it on your desktop/laptop?

[sander]

If it is RDP uncheck 'clipboard' on the tab 'Local Resources' before you start it, that helped me

[Thijs.Spruijt]

We use Excel via Citrix so no RDP

[tomok]

This isn't likely related to your crashing but it would be exceedingly bad design to be DBRWing and DBSWing into the same area(s) in the cube in the same spreadsheet. It's going to be almost impossible to predict with regularity how the precedence is going to worl. That's because DBRW's are bundled in network packets while the DBSW will have one formula per packet.

[Thijs.Spruijt]

Thanks for your reply. I will write some more VB that will clear out the DBRW formula's.So I will only have DBSW.

[David Usherwood]

@tomok, I recall being told by the IBM engineers at Black Belt in 2010 that if you used a VIEW() function for your DBSWs then you got the Stargate speedup. Can't say I have done a formal test myself though.