| Q: LiveWebs
appears to publish correctly, but the pages are not uploading to my FTP
server. I use a dial up networking connection and have selected 'FTP with
Dial-Up' and input the correct details. What is the problem? |
| A: A
key limitation for users of Windows 2000 and later is that LiveWebs
is unable to manage your dial up connection to the internet, in other
words it requires an internet connection to be available when it
publishes. This is only of significance to dial-up users, and users of
ADSL, leased lines, or any other form of 'always on' connection are
unaffected. |
|
| Q: In my converted web
page, why can't I see the table borders I had in my spreadsheet? |
| A: The cause of
this problem lies with web format itself. Basically, the specification for showing tables
in HTML is limited to the extent that your main option is either to have the same border
outlining every single cell in the table or no borders at all. You can specify this choice
in the HTML Range Setting tab of the LiveWebs Dialog Box.. |
| With some of the most recent
browsers, there is the ability to apply different border styles to individual HTML table
cells, however it adds significantly to the HTML code behind your web page, increasing the
time the page takes to display each time. Due to the limited availability of this
functionality in browsers today, LiveWebs 2.0 does not incorporate this functionality. |
|
| Q: In my converted web
page, no matter what table width setting I have set for the page in LiveWebs, it doesn't
come out right. What's wrong? |
| A: Unfortunately,
browsers often have their own ideas about how they are going to display a table and there
is not much you can do about it if they don't appear to follow instructions. This has to
do with differences of their interpretation of standard table-oriented HTML code. |
|
| Q: In my spreadsheet, I
had various drawing objects, like circles and boxes, which aren't showing up in the
converted web/HTML page. Why not? |
| A: At this time,
LiveWebs cannot unfortunately handle objects other than cell ranges and charts, whether
embedded or separate chart sheets. |
|
| Q: I set up some Table
Splits applying Custom views and filters, but I keep getting a message telling me that
there is no filter column in my view. I look at my spreadsheet and the filter column is
there. What's the problem? |
| A: Filter
settings by default are included when you add a Custom View in Excel, so be sure that when
you are trying to set filter values for the AutoFilter that the AutoFilter is indeed
contained in that Custom View. For example, if you defined a Custom View for use with a
Table Split in LiveWebs and then changed the AutoFilter later when working on the
spreadsheet (e.g. changed the number of column in the AutoFilter or set it to operate on a
different part of the spreadsheet) the AutoFilter available to your Custom View would
still be the AutoFilter which was in operation when you added that Custom View. LiveWebs
is not able to ascertain in advance whether you are trying to apply filter settings to a
non-existent AutoFilter; should this occur you are notified with a message telling you all
the details regarding which filter it is unable to apply your settings for, so that you
can make any modifications required. |
|
| Q: I was running LiveWebs
Markets with embedded charts in my worksheet. I am finding that elements of the graph,
such as the Legend, are gradually 'creeping' out of position. What can I do? |
A: This problem
appears to be a result of one or more bugs in the Excel product itself. We have only ever
been able to reproduce it when all of the following are true;
 | The zoom setting of the worksheet is not 100% |
| You are applying resizing to a chart using the
HEIGHT=n%,WIDTH=n% LiveWebs function |
| You have altered the 'default' settings of the graph from
when you first created it - for example, you have re-located the Legend over to the left
of the graph or you have custom-sized the chart plot area |
| There is more than one embedded chart in the worksheet
|
The only options currently available are workarounds;
either
| Make sure the zoom setting on the worksheet is 100% at the
time you set LiveWebs updating on a schedule (do not attempt to do this with a macro, it
won't solve the problem) or |
| Re-create the offending graph using the default sizing and
placement made by Excel or |
| Avoid resizing embedded charts or |
| change the location of the embedded chart to a chart sheet
or |
| restrict to one embedded chart per worksheet |
|
|
| Q: I was running LiveWebs
Markets, it works fine for several hours and than either a) I get an Excel message box
saying "Out of Memory" or b) Excel crashes with a fatal error message or c) I
get a LiveWebs Dialog box telling me there is an "Application or Object-defined
error". What's wrong? |
| There are 3 answers to
this question: A1: This
problem appears to be a result of one or more bugs in the Excel product itself. We have
only ever been able to reproduce it when the spreadsheet being converted contains chart
sheets or embedded charts. We delayed the release of LiveWebs 2.0 for a month believing it
was a bug in the LiveWebs code itself. However, Microsoft's own technical documentation
testifies to a disproportionate amount of Excel bugs relating to charts. |
| The situations in which we have
been most reliably able to reproduce it are when all of the following are true: |
| You are running Excel 97 on Windows 95 |
| The PC does not have a great deal of physical memory |
| You have a short updating period, just one, or a few,
seconds |
| You have graphs being converted |
| You have applied custom formatting to those graphs |
| In particular, we have found that applying the
"Round corners" setting to the chart area in an embedded chart produces the
problem most consistently |
|
| If you have this problem,
you need to delete all the embedded graphs in your workbook and re-create them (it's not
good enough simply to de-apply formatting), applying the minimum of formatting and
particularly avoiding round corners. Please also contact technical support, as we have yet
to have a customer who has experienced this bug. |
| A2: A variation
on this problem can come as a result of using Excel Custom Views in Table Splits, again
using Excel 97. This is another Microsoft-documented problem with Excel. Try the
following: |
| A3: Whilst we
have not so far been able to establish that it will help in all such situations, if you
are running Excel 97 without Service Pack 2, it is worth installing it. |
| Delete the custom views you are currently using, and
redefine them but this time make sure the 'Print Settings' tick boxed is not
ticked |
| If this doesn't work, try unplugging your printer - whilst
this isn't a satisfactory way of working, it should help diagnose that this is indeed the
problem |
| Lastly, try not using Custom Views at all - you can achieve
much the same affect by setting up a macro to hide/reveal certain columns when LiveWebs
runs. If we hear of customers who have experienced this bug, we will aim to make this
workaround more workable by adding the ability to run a macro on each table split. Please
contact us... |
|
|
| Q: I was running
LiveWebs Markets for a long period and Excel crashed without warning. What's wrong? |
| A: Again,
this problem appears to be a result of one or more bugs in the Excel product itself which
are documented by Microsoft. The circumstances in which we have been able to reproduce
this bug are as follows: |
| You have embedded charts which use background 'fill' effects, in particular,
texture effects or picture backgrounds |
| You are running Windows NT 4 Service Pack 3 |
|
If using a picture background which is not a gif,
Microsoft suggests converting the picture file to a gif and then re-selecting it as a
background
There is no workaround solution for background texture effects |
