Troubleshooting Publish Problems - Revision history

Nic at 23:28, 23 February 2015

2015-02-23T23:28:56Z

← Older revision		Revision as of 18:28, 23 February 2015
Line 32:		Line 32:
	=== Trust access to the VBA project model ===		=== Trust access to the VBA project model ===

	Compile errors can occur during publish as some worksheets contains code. To resolve this problem, see [[~~Turn on trust~~ access to the VBA project model]].		Compile errors can occur during publish as some worksheets contains code. To resolve this problem, see [[Trusting access to the VBA project model]].

	=== Do not include the menu when publishing ===		=== Do not include the menu when publishing ===

Nic at 23:28, 23 February 2015

2015-02-23T23:28:39Z

← Older revision		Revision as of 18:28, 23 February 2015
Line 24:		Line 24:
	=== Update Microsoft Office with all service packs, updates and hotfixes. ===		=== Update Microsoft Office with all service packs, updates and hotfixes. ===
	Finally, it is also recommended to ensure all service packs, updates and hotfixes for Microsoft Office are installed. Please contact your IT Support provider.		Finally, it is also recommended to ensure all service packs, updates and hotfixes for Microsoft Office are installed. Please contact your IT Support provider.


			== Compile errors during publish ==

			For some users, compile errors can occur during publish. There are various ways to resolve this problem.

			=== Trust access to the VBA project model ===

			Compile errors can occur during publish as some worksheets contains code. To resolve this problem, see [[Turn on trust access to the VBA project model]].

			=== Do not include the menu when publishing ===
			Including the menu on your publish reports may cause the publish to fail on some versions of BudgetLink. This is due to the fact that the menu contains some code which may not compile when included in a new workbook.

			Unticking the option to include the menu in the publishing dialogue can ensure that the publish completes successfully. This issue has been fixed in newer versions of BudgetLink.

Nic: /* Turn on the option to 'Cut, copy and sort inserted objects with their parent cells' */

2015-01-11T22:39:25Z

Turn on the option to 'Cut, copy and sort inserted objects with their parent cells'

← Older revision		Revision as of 17:39, 11 January 2015
Line 11:		Line 11:

	=== Turn on the option to 'Cut, copy and sort inserted objects with their parent cells' ===		=== Turn on the option to 'Cut, copy and sort inserted objects with their parent cells' ===
	Excel provides an option to 'Cut, copy and sort inserted objects with their parent cells'. It should be turned on in order to publish reports with charts successfully. For more information, see [[Turning on the option to ~~Cut~~, copy and sort inserted objects with their parent cells]].		Excel provides an option to 'Cut, copy and sort inserted objects with their parent cells'. It should be turned on in order to publish reports with charts successfully. For more information, see [[Turning on the option to cut, copy and sort inserted objects with their parent cells]].

	=== Adding a trusted location ===		=== Adding a trusted location ===

Nic at 22:38, 11 January 2015

2015-01-11T22:38:33Z

← Older revision		Revision as of 17:38, 11 January 2015
Line 10:		Line 10:
	For some users, charts can disappear when publishing. This seems to be especially common in Excel 2010 and Excel 2013. Not all solutions work but it is best to try each one until the solution is resolved.		For some users, charts can disappear when publishing. This seems to be especially common in Excel 2010 and Excel 2013. Not all solutions work but it is best to try each one until the solution is resolved.

	=== Turn on the option to ~~'''~~'Cut, copy and sort inserted objects with their parent cells~~'''~~' ===		=== Turn on the option to 'Cut, copy and sort inserted objects with their parent cells' ===
			Excel provides an option to 'Cut, copy and sort inserted objects with their parent cells'. It should be turned on in order to publish reports with charts successfully. For more information, see [[Turning on the option to Cut, copy and sort inserted objects with their parent cells]].

	=== Adding a trusted location ===		=== Adding a trusted location ===

Nic at 22:37, 11 January 2015

2015-01-11T22:37:08Z

← Older revision		Revision as of 17:37, 11 January 2015
Line 9:		Line 9:

	For some users, charts can disappear when publishing. This seems to be especially common in Excel 2010 and Excel 2013. Not all solutions work but it is best to try each one until the solution is resolved.		For some users, charts can disappear when publishing. This seems to be especially common in Excel 2010 and Excel 2013. Not all solutions work but it is best to try each one until the solution is resolved.

			=== Turn on the option to ''''Cut, copy and sort inserted objects with their parent cells'''' ===

	=== Adding a trusted location ===		=== Adding a trusted location ===

Nic at 23:39, 8 January 2015

2015-01-08T23:39:30Z

← Older revision		Revision as of 18:39, 8 January 2015
Line 32:		Line 32:
	Including the menu on your publish reports may cause the publish to fail on some versions of BudgetLink. This is due to the fact that the file format of the menu is different from that of the report. Unticking the option to include the menu in the publishing dialogue can ensure that the publish completes successfully. This issue has been fixed in newer versions of BudgetLink.		Including the menu on your publish reports may cause the publish to fail on some versions of BudgetLink. This is due to the fact that the file format of the menu is different from that of the report. Unticking the option to include the menu in the publishing dialogue can ensure that the publish completes successfully. This issue has been fixed in newer versions of BudgetLink.



			== Related Topics ==

			* [[Troubleshooting]]

	[[Category:Troubleshooting]]		[[Category:Troubleshooting]]

Nic at 23:39, 8 January 2015

2015-01-08T23:39:05Z

@@ Line 2: / Line 2: @@
 In this article, you will find many advice to fix various problems that arise when publishing reports.
 == Charts disappear when publishing ==
@@ Line 18: / Line 21: @@
 === Update Microsoft Office with all service packs, updates and hotfixes. ===
 Finally, it is also recommended to ensure all service packs, updates and hotfixes for Microsoft Office are installed. Please contact your IT Support provider.
 [[Category:Troubleshooting]]

Nic at 23:33, 8 January 2015

2015-01-08T23:33:01Z

← Older revision		Revision as of 18:33, 8 January 2015
Line 14:		Line 14:

	=== Repair or Reinstall Microsoft Office ===		=== Repair or Reinstall Microsoft Office ===
	~~As a last resort~~, it may be worth considering reinstalling Microsoft Office. Please ~~consult~~ your IT Support provider.		If the previous solutions do not help resolve the problem, it may be worth considering reinstalling Microsoft Office. Please contact your IT Support provider.

			=== Update Microsoft Office with all service packs, updates and hotfixes. ===
			Finally, it is also recommended to ensure all service packs, updates and hotfixes for Microsoft Office are installed. Please contact your IT Support provider.

	[[Category:Troubleshooting]]		[[Category:Troubleshooting]]

Nic at 23:29, 8 January 2015

2015-01-08T23:29:53Z

← Older revision		Revision as of 18:29, 8 January 2015
Line 7:		Line 7:
	For some users, charts can disappear when publishing. This seems to be especially common in Excel 2010 and Excel 2013. Not all solutions work but it is best to try each one until the solution is resolved.		For some users, charts can disappear when publishing. This seems to be especially common in Excel 2010 and Excel 2013. Not all solutions work but it is best to try each one until the solution is resolved.

			=== Adding a trusted location ===
	Adding a trusted location for BudgetLink is typically the best approach to resolve this problem. For more information, see [[Adding a Trusted Location in Microsoft Excel]].		Adding a trusted location for BudgetLink is typically the best approach to resolve this problem. For more information, see [[Adding a Trusted Location in Microsoft Excel]].

			=== Changing the default file format ===
	For Excel 2007, 2010 and 2013 users, ensuring the default file format of Excel is XLSM resolves many problems. For more information, see [[Changing the default file format in Microsoft Excel]].		For Excel 2007, 2010 and 2013 users, ensuring the default file format of Excel is XLSM resolves many problems. For more information, see [[Changing the default file format in Microsoft Excel]].

			=== Repair or Reinstall Microsoft Office ===
	As a last resort, it may be worth considering reinstalling Microsoft Office. Please consult your IT Support provider.		As a last resort, it may be worth considering reinstalling Microsoft Office. Please consult your IT Support provider.

	[[Category:Troubleshooting]]		[[Category:Troubleshooting]]

Nic at 22:59, 8 January 2015

2015-01-08T22:59:27Z

← Older revision		Revision as of 17:59, 8 January 2015
Line 9:		Line 9:
	Adding a trusted location for BudgetLink is typically the best approach to resolve this problem. For more information, see [[Adding a Trusted Location in Microsoft Excel]].		Adding a trusted location for BudgetLink is typically the best approach to resolve this problem. For more information, see [[Adding a Trusted Location in Microsoft Excel]].

	For Excel 2007, 2010 and 2013 users, ensuring the default file format of Excel is XLSM resolves many problems. For more information, see [[Changing the default Microsoft Excel ~~file format~~]].		For Excel 2007, 2010 and 2013 users, ensuring the default file format of Excel is XLSM resolves many problems. For more information, see [[Changing the default file format in Microsoft Excel]].

	As a last resort, it may be worth considering reinstalling Microsoft Office. Please consult your IT Support provider.		As a last resort, it may be worth considering reinstalling Microsoft Office. Please consult your IT Support provider.

	[[Category:Troubleshooting]]		[[Category:Troubleshooting]]