7 Replies Latest reply: Jul 2, 2014 8:42 AM by amith.madisetty RSS

    Smart View freezes excel

    fa1e4354-4eba-4947-9385-6aeeb2a2f7a3

      I have a specific excel sheet which, when opened in excel with active Smart View add-in, always freezes up. Disabling the add-in allows to open the sheet but as soon as the add-in is reactivated it freezes again.

       

      Windows 7, Excel 2010, Smart View 11.1.1.4.

      Following the advice fromExcel sheet hangs using smart view 11.1.2.2.000 I've changed the security settings and added the directory to the trusted sites, all to no avail.

       

      The error log is filled, but can't make much of it:

       

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 0375f4e2-694a-4868-a7a3-58246cac6083,0]Smart View handled an unknown exception thrown by MS Office.[[

        FILE: ..\src\addin\EssClients.cpp

        LINE: 7686]]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: b2180c5d-f6a8-45d7-b76d-cf8e15699663,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0][[

        FILE: ..\src\addin\EssClients.cpp

        LINE: 7686]]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 18cde4b3-2e03-4122-8412-2f6e8a2456c9,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Zoom In

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: e4870f0a-d0f6-4b0b-bb79-5e830b7bb5e2,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 7f73311b-4b2b-481e-a67a-112abc6da948,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Zoom O&ut

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 8c919c1d-9224-4649-9791-a74dd251c8aa,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 8b1d5f82-ae4a-467e-b1b8-23b466bb3d4f,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Pi&vot

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: f4de3dca-0f9a-4e29-996e-c96bc472db50,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 57dda34c-5b32-4f7a-89f2-d3f303482f94,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Pivo&t To POV

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: a0e86796-60b1-4b3c-a003-96df2e6fa47b,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 208305bb-d943-4c8a-be33-c4a1426d3331,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Keep Only

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 5212bdfe-aba8-4336-846e-fb44fe728e3e,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 717ac829-399a-468a-a708-ed9cbf3aacba,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Remove &Only

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 119c7855-8e69-4f39-8798-12b3b41dcbb3,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 38a17273-e4f7-4f13-be10-b568b5dc045e,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: View &Qualified Member Name

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 20d7206d-0af6-473d-9a18-aa7581ac9683,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: cb4486f8-4e5b-4183-802b-29a3de729e02,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Change Alias Table

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 7beec7ec-ea98-4eb5-a8b4-593afe0c623a,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 8f5e1071-358b-4bb8-ac94-b025fdfa0d4d,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Select &Form...

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 3c71fea5-8053-464a-aade-bbcb50bada17,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 3029319d-17c5-4972-a680-860c95419343,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Instructions

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 2198a323-aa9f-4989-9bb4-2ff618a77c6b,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 27d234bb-8eda-45f9-a8d2-99f3094db08b,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Add &Member

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: f4c3fea2-e806-466f-be0c-61b403b9cfde,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: f30a0e5a-50bc-4494-a033-197bb7401c5f,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Take Offline

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: a052a456-b6be-4652-88aa-e4ef180d765c,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: ea0c1f55-4231-40cb-a730-8955eba5acd5,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: S&ync Back To Server

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 6fb0dc89-4022-4630-8591-845dfb0c0c84,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 30244c03-0d56-487e-a18f-7a9100388b72,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Refresh Offline Definition

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 6390dcbb-d424-4cf6-b92a-60ac5b85810a,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 304f8ea4-1dcf-4b0d-9cea-37576dbbbe5e,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Lock

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 1e9f8ae2-fe38-4667-aff5-ec954b88f593,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 129a7deb-d804-4646-ada1-d3a3929f6f19,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: E&xpand

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 58cb46c9-5550-4e74-bf36-bb245e3eb1c7,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: ecb465bc-eb92-4468-9010-738a11ef87f0,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Colla&pse

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 31b9ec4e-6ede-4703-ad01-2fc4029613f3,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 097443e3-c32b-4510-aef5-c0c1b978b0c4,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Functio&n Builder...

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 371d9762-1620-446a-9114-192544ba3eca,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 08206fed-1e55-4b2d-be25-695937230023,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Mi&grate Active Workbook (Financial Management)

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 9bbc600c-5060-492e-9b51-9f7ad32ddf4f,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 5137d781-eb3b-4bc5-b02c-2a28c29ffdfb,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Migrate &Batch (Financial Management)

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: b5271b2c-2329-470c-9b68-217efc73b3d0,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 3250da0d-a923-4ae7-b0e3-88eec9351172,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Insert Connection List

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 1fd6c024-898c-412f-84c9-5cb6db321f63,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 05fbded3-6f19-42ea-88bd-941fca4cedb3,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Import

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 37df99aa-ac09-4b93-b214-1f588f7fc311,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 7c791fb0-dc2e-4242-a412-5b18b31e539a,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Edit

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 106c2601-89b0-47ee-8aa5-6bff1ea20015,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: e947c972-8d32-43a5-86c4-f8cd98e63bb0,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Calculate

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 102ce76d-6cbe-43af-b429-c19154dc1da7,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: fb3deff7-38cf-4a94-8052-b153ac5b988c,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Force Calculate

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: ba2d6fd2-04ae-4d02-9458-947d6ad48a2f,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 8c918497-d6aa-4294-a3b3-f2eb56248d1a,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: C&alculate Contribution

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 84fa3b44-6b93-4334-83f3-723fb3fa5e00,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 178b086a-3fac-4e2d-9c4f-c5bd132b3c45,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: F&orce Calculate Contribution

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 87bbcf86-18c5-4e6c-991b-be52bf3bbcb7,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 1cd7d020-6d80-4ea4-9173-d705b68431e6,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Translate

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: e46af393-2aa5-4c6a-a4e1-cdaf76ea0fbf,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: c55d1afc-1ec1-4c4b-ab97-130aff1eb0fd,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Fo&rce Translate

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: d30e161e-70c2-4511-b75b-e2226bfb7684,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 7744b343-b7e3-4844-9de9-8ce052d9e401,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Co&nsolidate

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: e6f2964b-e3c7-475f-9305-85762a2ba01d,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: f38970bc-dbc6-47c4-abe6-e948da070940,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Con&solidate All

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: cb75921c-50de-4081-abc7-dc63a65d3fa9,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: ba18028d-8c05-43dc-b485-a0e7a863a98c,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Conso&lidate All With Data

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 9fac659e-cc50-4b8d-b59d-2d6ab3cbc14b,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: d4f7d568-3edc-45d5-8f00-91eb00eb1663,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Business Rules

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: a0ed5def-cf15-4aeb-a6a2-775d3f6dd35d,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: b2ad63bb-3e48-4770-b40b-e80da4af719c,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: R&ules on Form

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 669e1d7d-f3ff-4350-b862-d59ba0a1a7c3,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: b40b7e5d-b0ad-46ea-af8b-fe6aade147f9,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Query Designer

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 2d241796-756a-41d3-b97f-e69bdc9d09ae,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 6b8f9705-7a44-463f-9934-612393facd2c,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Run Report

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 32fea7df-faad-448d-a81b-f30641b70995,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: fb0aced1-fe9b-439a-8ef5-affed52f8624,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Execute MDX

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 398d5a51-476e-4122-a77b-5b94d707fda0,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: c5a7e8f4-149a-489f-8256-2c26a7b3374b,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: &Data Filter

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: ad635efe-e080-4b66-9440-b420f39c10a8,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: ed983483-622e-45b0-a7d3-52dfb5dfe1a8,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Visualize in &HVE

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 0706dd46-ce37-48c4-bcd9-7a03e2fd1197,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC-1][SVC][ecid: 97afb04f-2ef7-40f7-9d38-aeaf44713a1e,0]Error in CEssSpreadsheet::SetMenuItemEnabledInMenu setting menu item: Visualize in &Excel

      [2014-07-01T15:29:17Romance Daylight Time][SVC][ERROR:1][SVC0][SVC][ecid: 4c51641c-991f-4207-a639-4f889c260dd8,0]COleDispatchException [Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0]

       

      Any suggestions?

        • 1. Re: Smart View freezes excel
          KKT

          In  SmartView / Options / Member Options the "Preserve Formula on POV change" should be unchecked Smartview will hang when switching to Formatting Options.

           

           

           

          Also Excel and IE security settings are likely interfering. Try adding smartview folder as trusted site in Excel. check the macro settings as Excel sees the addin as a maco. Also take off the safemode settings. For internet explorer, make sure the server site is added to the trusted sites and that zone security is set to low.

           

           

          Thanks,

          ~KKT~

          • 2. Re: Smart View freezes excel
            fa1e4354-4eba-4947-9385-6aeeb2a2f7a3

            Most of that was said in the other thread already and doesn't work.

             

            Preserve Formula on POV change: was already unchecked

            Try adding smartview folder as trusted site in Excel: was already done

            check the macro settings as Excel sees the addin as a macro: -> what do I need to check?

            Also take off the safemode settings: was already done.


            Internet explorer doesn't come into play here for me... only excel and smartview for now. Haven't even had a chance to make a connection yet.

            • 3. Re: Smart View freezes excel
              fa1e4354-4eba-4947-9385-6aeeb2a2f7a3

              Does this part in the error log "[Automation is not ready (VBA_E_IGNORE)]" mean anything? Could it be there is some error in the VBA which causes excel to freeze? I found some info that this code should be in a loop to cath the error: Microsoft Visual Studio: HRESULT 800ac472 from set operations in Excel - visual-studio.questionfor.info

              • 4. Re: Smart View freezes excel
                LRBS

                I have had similar symptoms.  However, I did not see the same error messages, so this is just a shot in the dark.

                 

                Is this an old spreadsheet that has been around for a while, or has it just been developed.  Older spreadsheets often have MS Excel settings that did not cause a problem in the past, but do cause a problem now.  The one I ran into is as follows:

                 

                Make sure "Lotus Compatibility" is not checked (any of the options).  As this will cause Excel with Smartview to Freeze or Crash.

                File|Options|Advanced| then scroll to the bottom.

                • 5. Re: Smart View freezes excel
                  fa1e4354-4eba-4947-9385-6aeeb2a2f7a3

                  Lotus Compatibility is not checked... so that's not it :s More suggestions? Keep 'm coming


                  About the sheet, it has recently been developed, but I am getting an error each time I open it: "The file you are trying to open, '[filename]' is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"


                  However, when I change the extension from .xls to .xlsx it refuses to open, when I open it and save as .xlsx I can open that one without any problems. The file is from a trusted source yes...

                  • 6. Re: Smart View freezes excel
                    fa1e4354-4eba-4947-9385-6aeeb2a2f7a3

                    FYI: I've rebuilt the sheet from scratch in a separate workbook. That one works.

                     

                    So must be the workbook causing the problem...

                    I've only reworked the tab which makes use of HsGetValue, without anything else. I'm starting to wonder if it's because now I don't have any VBA code left, seeing also the error log as posted before, which included "[Automation is not ready (VBA_E_IGNORE) - 800ac472 - 0] "

                    • 7. Re: Smart View freezes excel
                      amith.madisetty

                      Good that its working, !! yes if its the problem only with specific template then it is something to do about the functions and size of data it is trying to pull.

                       

                      BTW was that sheet ever opened fine ? and did you try to edit the sheet to limit number of rows which would cause less amount of data to be pulled . ?

                       

                      Thanks

                      Amith